Adding rows to a Excel file (dynamic name)

(1) Share

Report

Posted on by Manarjomar

248

Hi there,

I have a flow to add rows from SQL to EXCEL using powerapps. This one working well with an static file and now I want to add a variable with the path and filename send from powerapps, however doesn't work in this case. Really I can't save the flow becasuse it try to find the fields.

With static file works fine:

Is it possible do it? Any idea?

Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Michal1 4 on at

Like (0)

Report

I had the same issue and i used variables for location, library, file and so on but before action add rows to excel i used compose action to create "structure" of my table.

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

Like (0)

Report

How did you get LibraryID ?

Was this reply helpful? Yes No
Michal1 4 on at

Like (0)

Report

This way. I use action Send an HTTP request-> PARSE JSON body of previous action->filter array (i use enviromental variable that stores my library name)-> set variable with my LibraryID

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

Like (0)

Report

Hmm thanks I'll try that, I did something similar but always ended up getting a "malformed library id" error.

Was this reply helpful? Yes No
ZsoltDaBeast 30 on at

Like (0)

Report

Hi Michal,

Could you please explain the "file" section on your screenshot, please?

Thanks

Was this reply helpful? Yes No