Hi Follow the below steps: 1. Create a table for the pre-existing Excel file. This is a manual step. 2. Next create a flow - Add a Dataverse trigger when a new record is created. 3. Next use add a row action step excel for creating the new items in excel Thanks
Can you maybe do this question from the powerplatform forum: I have the flow which getting two set of data from two table (which are stored into two different excel files) and I want to merge the two into a single table by appending the data from the table in excel file two into the table into excel file 1. Both of them have one common primary key which is unique (an e-mail adress) I want combine both table into single table for each row return from the table in the second excel file, I tried with a for loop but could not make it work. Any solution on my problem here? Any help will be great.
Could you take data from a MS form where they have uploaded a image and insert it into a field within d365? So upload a image to CRM from the form entry using power automate?
@@abm4975 Hi! Using MS forms to capture user input, using my flow to run a bunch of conditionals, then using that data to create a case record in CRM CE. I know you can upload a image into a ms form, but not sure how to take that and put it in CRM in a field
What If the mothly employee table had several employees in the same department with a unique department id and a column of salary amount per project that needed to be to added before sending to the Employees table, How would I add the values for each unique department id before I send that total amount to the Employees table under department salary total?
Hi Apologies for the late reply. Could you please post this in Power Automate community forum. Tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Hi You need to apply pagination. There are lots of article regarding this. Here is one. softchief.com/2021/12/11/retrieve-more-than-5000-records-from-dataverse-or-dynamics-365-in-power-automate-using-fetchxml-paging/ Thanks
Very useful, thanks :-) Can you please help me create a flow to count the no. of customers per employee in Customer table and then update column "No. of customers" in the Employee table with the counted number for each employee whenever a change is made in the Customer table?
Hi@@abm4975 Thanks a lot for replying. Yes, this is dataverse. Both employee and customer are text columns. In customer table I also added a yes/no - 1/0 column, thinking it might be easier to sum or count this numeric value.
Hi Santhosh Just checked it again and the audio is there. As you can see there are quite a few comments from this video and none of them reported it. Thanks
Very informative sir…keep making on power automate flows
Thanks for your support.
Thanks for this great Video. Helps a lot!!! ☺
Thanks
Thanks a lot for sharing this really helful content.
Thanks a lot
Could you please help me out on updating the pre-existing Excel spreadsheet when a new item is added in dataverse table using powerautomate?
Hi
Follow the below steps:
1. Create a table for the pre-existing Excel file. This is a manual step.
2. Next create a flow - Add a Dataverse trigger when a new record is created.
3. Next use add a row action step excel for creating the new items in excel
Thanks
Can you kindly explain how to upload all the newly created CRM contact or lead data to SharePoint using power automate
Hi
Use Dataverse action step called 'When a row is added, modified or deleted'
Thanks
Can you maybe do this question from the powerplatform forum:
I have the flow which getting two set of data from two table (which are stored into two different excel files) and I want to merge the two into a single table by appending the data from the table in excel file two into the table into excel file 1. Both of them have one common primary key which is unique (an e-mail adress)
I want combine both table into single table for each row return from the table in the second excel file, I tried with a for loop but could not make it work.
Any solution on my problem here? Any help will be great.
Hi
Its not easy to explain here as by comment. Check my Channel about section and contact me via email. I could offer a screenshare help.
Thanks
@@abm4975 Thank you for your swift response! I will research your channel. How much would you charge for screen sharing help?
I don't charge for screenshare. Its a community work. Thanks.
Could you take data from a MS form where they have uploaded a image and insert it into a field within d365? So upload a image to CRM from the form entry using power automate?
Hi
Are you using Microsoft Forms or Customer Voice Forms (From Pro)?
Thanks
@@abm4975 Hi! Using MS forms to capture user input, using my flow to run a bunch of conditionals, then using that data to create a case record in CRM CE. I know you can upload a image into a ms form, but not sure how to take that and put it in CRM in a field
Hi
Do you still need help in this?
Thanks
@@abm4975 Yes! I was hoping you would be able to make a video taking a image uploaded to a MS form and inserting it into a field in D365
Hello! what if i need to get excel data from sharepoint? how can that work? thanks in advance!
What If the mothly employee table had several employees in the same department with a unique department id and a column of salary amount per project that needed to be to added before sending to the Employees table, How would I add the values for each unique department id before I send that total amount to the Employees table under department salary total?
Apologies for the late reply as I was away and busy for last few weeks. Do you still need help in this? Please let me know. Thanks
this video is great, can you share how to aggregate a value and update to another list.
Hi
Apologies for the late reply. Could you please post this in Power Automate community forum. Tag me as @abm. I will have a look.
powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
If table has 2 lakhs records how can we pull the data in logicapp
Hi
You need to apply pagination. There are lots of article regarding this. Here is one.
softchief.com/2021/12/11/retrieve-more-than-5000-records-from-dataverse-or-dynamics-365-in-power-automate-using-fetchxml-paging/
Thanks
Very useful, thanks :-) Can you please help me create a flow to count the no. of customers per employee in Customer table and then update column "No. of customers" in the Employee table with the counted number for each employee whenever a change is made in the Customer table?
Hi
Thanks for your question. Couple of questions.
1. Is this Dataverse?
2. What's the datatype if employee and customers?
Thanks
Hi@@abm4975 Thanks a lot for replying. Yes, this is dataverse. Both employee and customer are text columns. In customer table I also added a yes/no - 1/0 column, thinking it might be easier to sum or count this numeric value.
Thanks for your reply. Could you connect me via teams. See my contact email from Channel > About section
Can you make a video on how yo change the format of the file .. example from .7z file to .zip file or from zip to .txt file etc.
Hi Lerisha
I am not sure you can just convert a zip file to txt file. All file extensions have its own way of encrypting the content.
Thanks
@@abm4975 thank you sir😊..it's okay
Thanks it worked me
You're welcome!
Awesome!
Thank you! Cheers!
Get a good mic and a digital recorder for your audio. Your videos will improve greatly.
Thanks. Will do.
No sound in this video
Hi Santhosh
Just checked it again and the audio is there. As you can see there are quite a few comments from this video and none of them reported it.
Thanks