cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zrouatbi
Frequent Visitor

Bulk load of data from Excel to Dataverse with PowerAutomate

Hello Everyone,

 

I am new to PowerApps and I am struggling with this challenge for more than 2 days, I hope someone could help me here.

Basically what I am trying to do it, I have an attachment control linked to a Button that collect the attachment in PowerApps, I need to load the data from the attached excel file into a dataverse table when the button is clicked, using PowerAutomate, I can see Add a New Row step for dataverse , where you select the table and columns but I have no idea how to map the columns from the excel file to the dataverse table.

 

Can you please help?

Thank you so much

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-JessicaG-msft
Community Support
Community Support

Hi @Zrouatbi ,

 

I'm afraid it won't meet your needs in Power Automate. As far as I know, if you want to use the data in excel to update the content of other files in flow, the excel file should have been created, but it is currently not possible to extract the Excel data from the Power Apps attachment to create the file.

 

I found the relevant link, please refer to :

https://powerusers.microsoft.com/t5/Building-Power-Apps/Extract-Excel-data-from-Power-Apps-Attachmen...

 

Best Regards,

Jessica Gu

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

First you need to use another connector to open your excel file.     (depending where the excel file resides, you will use excel online business or onedrive).

 

leonunescouto_1-1640291655365.png

 

 

 

 

 

See below an example:

leonunescouto_0-1640291498857.png

Hope it helps you..

 

Leo

DeviKrishna
Super User
Super User

Hi @Zrouatbi ,

 

From attachment control try uploading your excel to sharePoint. Then you can read the excel from SharePoint and create records in Data verse. You can follow this video for step by step instruction to read excel from SharePoint list - https://youtu.be/8GWj6UEn-44

-------------------------------------------------------------------------
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

 

Hi Leo,

 

Thank you very much for your answer, I am actually using Attachment control from Powerapps to pick up the file then I need to load the data from the  file to a dataverse table using power automate.

 

Can you help here?

 

Many thanks

Zied

Hi Devi,

 

The problem here is that the file shouldn't be moved anywhere in between during the flow process, simply the file should be uploaded in PowerApps by the attachment control and moved to a dataverse table by Power Automate, no SharePoint should be involved.

 

Do you have any other solution?

 

Many thanks

Zied

Hi @Zrouatbi ,

 

Have you looked into below blog which uses PCF control for excel import in power apps.

 

https://www.bythedevs.com/post/pcf-to-upload-excel-data-to-canvas-app-in-power-apps

 

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Hi @bipinshan ,

What I need here is extracting the data from the attached excel file in the (Attachment Control) and move the data into a dataverse table.

 

Thank you

Zied 

v-JessicaG-msft
Community Support
Community Support

Hi @Zrouatbi ,

 

I'm afraid it won't meet your needs in Power Automate. As far as I know, if you want to use the data in excel to update the content of other files in flow, the excel file should have been created, but it is currently not possible to extract the Excel data from the Power Apps attachment to create the file.

 

I found the relevant link, please refer to :

https://powerusers.microsoft.com/t5/Building-Power-Apps/Extract-Excel-data-from-Power-Apps-Attachmen...

 

Best Regards,

Jessica Gu

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (3,978)