Answered

Reading Onedrive business excel file data

(1) Share

Report

Posted on by Amin403

Hello All,

Hope your doing well....

am following the power automation training course in that tried to do recurrence flow by using "Reading OneDrive business excel file data.".

I am not able to get the table values dynamically even after following the document.
Doc link: Exercise - Create recurring flows - Training | Microsoft Learn

Can anyone of you please check and help me out on this.

@Pstork1 Please suggest me here to overcome the issue

Kudos to you in advance...!

Thanks,

Amin Shaik.

Categories:

Using connectors

I have the same question (0)

All responses (10)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Amin403,
Please try to delete the ‘List rows present in a table’ control, then add this control, and then select Table.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Amin403 20 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yetonggu-msft ,

Thanks for the quick reply....

had tried to delete the ‘List rows present in a table’ and then tried to add same by selecting the table content in input excel file but there is no luck still am not getting the table details.

Can you please try to explain me in detail...

Thanks,
Amin Shaik.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Amin403 ,
I guess you insert the table in the Excel file when creating Flow (the table in Excel is inserted before creating Flow), so Flow did not detect the table you just inserted.
I suggest you delete the 'List Rows Present In a table ', and re -add the' list rows present in a table 'control to achieve synchronous update of data sources and Flow.
In this way, the table you created will be detected by Flow.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Amin403 20 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yetonggu-msft ,

No, the data table in the excel exists previously am using the old file, which is already exists in OneDrive, though it is not showing.
Had refreshed both one drive and power automate flow couple of times still no luck, had tried to change the data in the excel as well still no dynamic table content is available.
am sure am following as per the document
link: https://learn.microsoft.com/en-us/training/modules/get-started-flows/6-flow-scheduled-flows
not sure why it is not working for me😑

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Amin403 ,
Please create a new Flow and add only one 'get tables' control to see if you can get the information of the table.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Amin403 20 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yetonggu-msft ,
Had tried the same below is the result I see the flow get succeed but the output data is not like your flow.

and I see one main difference is in your flow it is showing only the file name whereas in my flow it is showing entire its location path.

Thanks,
Amin Shaik.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Amin403 ,
Please find the id title in the 'Get tables' control, copy the id content, and fill in the table's id into the 'list rows present in a table' control.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Amin403 20 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yetonggu-msft ,

I am not able to find the ID type in my resulted output body.
But I can see my flow ran successfully.

My input file.

Thanks,
Amin Shaik.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,427 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Double check that you have a table in the Excel file. If you open the file in Excel and place your cursor in the table you should see a 'Table Design' menu tab that will show you the name of the table.

Was this reply helpful? Yes No
Amin403 20 on at

Like (0)

Report
Copy link

Link copied!

Hello @Pstork1 ,

Kudos to you for your support😊.... It is working now.

@v-yetonggu-msft Thanks for your quick response on my issue😊.

Thanks,
Amin Shaik.

Was this reply helpful? Yes No