You’re offline. This is a read only version of the page.
20
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.
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.
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.
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
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.
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
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😑
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
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.
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
Share
Report
All responses (
Answers (
