Reading Onedrive business excel file data

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

[v-yetonggu-msft]

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

[Amin403]

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.

[v-yetonggu-msft]

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

[Amin403]

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😑

[v-yetonggu-msft]

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

[Amin403]

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.

[v-yetonggu-msft]

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

[Amin403]

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.

[Pstork1 · Accepted solution]

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.

[Amin403]

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.