Unanswered

Excel files in one drive to dataverse

(0) Share

Report

Posted on by deerzzxdell

I want to create a flow which there will be daily upload of multiple excel files which has similar columns in my one drive business folder. Then after the files in upload to one drive, they will immediately update into a dataverse.

I use one drive trigger 'when file is created (property only)' and turn off 'split on' in setting. In this case do I need to use get file content to get all the rows in the excel file?

And can you explain the solution in detail.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @deerzzxdell

Check below post for your reference

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Import-Data-from-Excel-To-Dataverse/td-p/1388909

https://piyushksingh.com/2020/07/06/power-automate-read-excel-file/

You can use as below

1. List rows present in a table

2. Apply to for each and Add a new row - Dataverse

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @deerzzxdell ,

According to your description, you want to add the excels' rows to the Dataverse.And you turn off the "Split on" options.

So your Trigger supports fetching multiple Excel files at the same time. But according to my tests, the return value of this trigger is not the content of the file, but some information about the file:

So, if we want to get the content in the corresponding excel, we still need to use Apply to each to get the data in each file, and then use Apply to each to add each row to our Dataverse.

Here are the steps you can refer to :
(1)This is my two test files:

And this is my dataverse table:

(2)My flow is like this:

Then we can make the data in our excels to Dataverse Table:

Best Regards,

Wearsky

Was this reply helpful? Yes No
deerzzxdell on at

Like (0)

Report

hello, @v-xiaochen-msft thank you for providing the explanation. I still have one more question about your flow. In the first apply to each, you've use List of files as your input from previous step. But when I look through my dynamic content for that apply to each in PA, I couldn't find it.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @deerzzxdell ,

Thanks for your quick response ! The first step is used the "When a file is created (properties only)" output .

And this is the output for it and we can test in your side to see if the same as mine:

And also , you can use the " triggerOutputs()?['body'] " to get the array we need to use in this step.

Best Regards,

Wearsky

Was this reply helpful? Yes No
deerzzxdell on at

Like (0)

Report

Hello @v-xiaochen-msft This is the raw output after I ran the flow. I have uploaded 2 excel files in OneDrive but only 1 appears in the body{}

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @deerzzxdell ,

Have you turned off the 'Split' in trigger setting?

Best Regards,

Wearsky

Was this reply helpful? Yes No
deerzzxdell on at

Like (0)

Report

Thank you! I have sort out that problem now. I have another question in action List rows present in a table.
I couldn't retrieve the value table. So I enter the custom name 'sheet1' but the flow got an error like this
Also the output value in my Get tables is blank [] , should it be like this?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @deerzzxdell ,

Thanks for your quick response !

The Table name is the Table in your Excel sheet . So you said that the "Get tables" return blank in your side , you need to check if the excel data has convert to a table in Excel:

And this is the Table Name in Excel and not the Sheet Name:

So you can first convert to a table and then test if you can return an table name in the "Get Tables" step:

Best Regards,

Wearsky

Was this reply helpful? Yes No