Create excel table when a file is created in sharepoint

[LuisGuzman98]

Hello,

Got a team that needs to update a sharepoint data base.

Data of the sharepoint data base come from a CRM. 

My solution by now is for them to: 1. Run a report in the CRM with the data they need -> 2. Download the report as an excel file -> 3. Upload the excel file to a sharepoint folder (Trigger action of the flow) -> 4. Create a table with the excel file uploaded -> Update the sharepoint list & add the new items with the data obtained from the process. 

I don't know how to do this by now, it is retrieving an error when testing. this is what I have thought by now. 

This is the error message with the actual set up: 

 "Cannot find resource for the request csv."

I really don't know what to do. Please help!

[yashag2255 · Accepted solution]

Hi @LuisGuzman98 

A few limitations of the Excel online connectors in flow is that 

You cannot dynamically provide a file to the file option on the action. You will actually have to click the folder icon and navigate to the file and select it. This means that your excel file needs to be present in the document library and only then you can access it in the Flow. If you are creating an excel in the flow and want to access it in that flow only, it is not supported directly right now. 

Same goes with List rows in a table action where you will have to provide the file and then the table too. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[LuisGuzman98 · Accepted solution]

Hi me, 

Already found the problem:

1. The File slot should be filled out for this case with the 'File identifier', not the file name. That was a main problem. 

2. The excel File i was uploading wasn't a normal type of excel it is called: 'Microsoft Excel Comma Separated values', apparently (or at least for me) this type of file doesn't work with flows excel online connectors even though it could be opened with it. **Just worked when the file was a normal 'Excel workbook' type of file.**

So I was uploading this type of unreadable file for flows and trying to reach to it with all the dynamic vatriables and all gave some error because of that.

The correct variable for this action  it is the sharepoint file identifier. 

[Alaor]

You have really made a someone happy today ! Thank you for sharing this solution !