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

All responses (5)

Answers (0)

Sort by

Michal1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

How did you get LibraryID ?
Michal1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

Hi Michal,

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

Thanks