Answered

Button flows and uploading new files

(0) Share

Report

Posted on by Community Power Pla...

Hi!

I have issue. I want to merge 4 excel files into one. 1st file is on the sharepoint. Second one is the same always and i don't have any problem with that. The problem is 2 files which I upload by button triger and I choose them from the computer. Flow is uploading them, creating new files, listing rows and updating them. However update a row don't work because its like new file have new id or anything and this action can't find uploaded files. I try using phrase JSON and using list folder to get dynamic path. These paths don't work with update a row and error is "can't find a file".

So I need upload new files and update a rows with new files.

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Button flows and uploading new files

Hi @Anonymous

Could you post a screenshot please?

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Button flows and uploading new files

It should look like that. However the problem is it stops work after 1st use. Its like list a rows loses file id and path isn't enough to find a file as i said. I tried to phrase path, to make dynamic expression and still I can't do anything. It's important to upload files with button.

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Button flows and uploading new files

Hi,

Could you please tell me what's the update you are trying to do? How many Excel files you are creating via Flow? Or is it all uploaded via trigger?

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Button flows and uploading new files

As I wrote before. I'm creating 1 excel file and I try to update that with 3 files. One from sharepoint. Two from button trigger with upload a file. The one from sharepoint work perfectly, two from upload are the problem.

Now I try to list a folder. It works somehow with ID however I try to split ID by JSON however still don't know how to do it.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Button flows and uploading new files

Hi @Anonymous ,

I recommend that you store the other two Excel files in the SharePoint Library or OneDrive first so that the List rows present in a table action can parse out the data contained in the table.

If you upload files from your PC and then dynamically configure List rows present in a table action and get data, this seems to have limitations. I have made similar attempts, but it seems that they are not feasible. I am afraid that such requirements cannot be achieved by relying on current functions.

Please refer to the link below for more details about Excel Online connector:

https://docs.microsoft.com/en-gb/connectors/excelonlinebusiness/#known-issues-and-limitations

Best Regards,

Was this reply helpful? Yes No