Announcements
Hi, i need to import excel data to dataverse table dynamically using power automate. Please help !
Hi @MrShivam ,
You can use Excel Online List Rows action in Power automate to retrieve rows from excel sheet.
You will need to upload your excel file on Onedrive.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/
@bipinshan actually i have an attachmmet control in canvas app and i want to import data through that attach. control also my excel sheet will be uploaded dynamically. Trying to use this flow but its not working properly.
Hello @MrShivam,
Will the Format be same all the time?
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
Can you please expand each boxes in your screenshot of power automate action to know exactly what you are doing in your flow?
Are you using sharepoint attachment control in your canvas app to upload excel file?
what are you passing it to from from canvas app when you are calling the flow ?
You will need to add apply to each action before add a new row action -
Please refer the below link,
https://piyushksingh.com/2020/07/06/power-automate-read-excel-file/
As @Ramprakash asked will your excel structure keep changing every time for the same data verse table?
-------------------------------------------------------------------------If I have answered your question, please mark your post as Solved.If you like my response, please give it a Thumbs Up.
My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A
Regards
Devi
@bipinshan Yes, sharepoint attachment control. What should i pass to import excel to dataverse
@rampprakash Yes format will be same
@DeviKrishna No, Structure will be same
Check below video.
https://www.youtube.com/watch?v=EHONWkYQNGA&t=188s
Hi @Shivam,
If the structure is same you can use the sample flow I have created. I tried to create contacts from excel and it works perfectly.
I have created an excel in sharePoint site. under Documents folder. Please refer below screen shot.
You can take the solution for flow and also the sample excel from the attachments here.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
