I have a flow that takes an excel file from OneDrive and writes the data to SharePoint. The excel file is created dynamically everyday by a program. After I create the flow, it works. It is scheduled to run once daily. It works for 2 or 3 days then starts failing consistently with the error messages below.
This is how it is setup
The only difference I see in the hex values is that the values in the setup are in lower case whereas the values in the error message are in upper case. I don't know if this makes a difference. I would appreciate any help
you might have to look at the excel file to make sure that it actually contains a "table" (format as table)
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.
Hi @Davinci ,
First, please check the table exists.
Secondly, if your Excel file is uploaded regularly or you are needing to dynamically reference your Excel, you will need to use the Get Tables action and then passing the correct table name into List rows in table.
Please see below as an example. You can add a condition in the loop to find the correct table if you have multiple.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Thanks
Hi @eric-cheng
Thanks for your help.
I followed the same scheme as you described above but I am not getting the option to enter the table name. The only option available is Table 1 with a hex value of {00000000-000c-0000-ffff-ffff00000000}. So I choose it.
When I test it one time it works. When I test it the next day I get an error message stating that the flow is looking for Table1 {00000000-000C-0000-FFFF-FFFF00000000} (where the hex numbers are in upper case)
I am passing the correct table name but when the flow runs, it is looking for upper case hex numbers instead of lower case. See second image below
Hi @Davinci ,
Can you delete and readd the action.
1) Add the List rows in a table action
2) Click on Enter custom value
3) You should now be able to select Table Name
4) The flow should automatically move your action inside a loop
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn
Hi @eric-cheng
I am not getting the option to choose the "File" variable as you did. Please see image below.
What am I missing?
Hi @Davinci ,
For file, just specify the same filename in your Get Tables which you have statically set.
For Table, specify the Name dynamic content value from your Get Tables.
Thanks
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
23 | |
17 | |
11 | |
10 | |
8 |
User | Count |
---|---|
31 | |
27 | |
26 | |
17 | |
16 |