Create file (Excel to SP Doc Lib) > Create table > Item not found ??

[Julien1]

Hi,

A flow is working for some users, and some others not.

1. Power App trigger
2. Create file (in a SP Doc library) - that file is an Excel template with always the same structure
3. Adding a 10 sec delay ... but didn't fix the issue
4. Create table - Fails because Item (file) not found, but, it is of course present in the document library PVA_Tool_Temp

That person was able to access and edit the Excel file that had been uploaded with the flow to the SP doc lib, using the link 

https://x.sharepoint.com/sites/XXXX/PVA_Tool_Temp/temp_PVA_637812996499327231.xlsx

[Mister_Shaik]

H @Julien1 ,

The excel actions that are used in Power Automate always refer to file GUIDs and Table IDs rather than the names or path to files, which is why if you pass a file path in the file property it's expected to fail.

In order to get the file GUID you can use the get file properties and extract the guid from the thumbnail property. Below is a screenshot of how you can do it,

first(split(last(split(outputs('Get_file_properties')?['body/{Thumbnail}/Small']
,'items%2f')),'%3f'))

Outputs:

In the screenshot, you can see that I've used a "Get file properties"  to get the file details and then under the File input for "Create Table" I have used an expression to extract the GUID of created file. This made it possible to create a Table dynamically.

Hope this helps 🙂

Kind Regards,

Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[VipulSharma1556]

Hi, I was experiencing the same issue today. Tried a bunch of things, even CoPilot didn't know 😁. Finally landed on this answer and this is it. Able to create the table now. Thanks, mate!