Bulk load of data from Excel to Dataverse with PowerAutomate

(0) Share

Report

Posted on by Zrouatbi

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

See below an example:
Hope it helps you..

Leo

Was this reply helpful? Yes No
Devikumari Krishna 988 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Zrouatbi 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Zrouatbi 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Bipin D365 971 on at

Like
a
(0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Zrouatbi 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-JessicaG-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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-Attachment/td-p/554084

Best Regards,

Jessica Gu

Was this reply helpful? Yes No
Roger_Ullilen 8 on at

Like
a
(0)

Report
Copy link

Link copied!

lo que yo haría es esa data que cargas se guarde en una ruta de Sharepoint y luego leer esa data con automate finalmente agregas el paso de Dataverse y asignas las columnas correspondientes, al agregarlo te lo va meter en un Apply to each con eso se soluciona.
Debes de tener en cuenta que esa data de información debe tener formato de tabla

Was this reply helpful? Yes No