Unanswered

Add a row into a table returns only a single blank row

(0) Share

Report

Posted on by DB15

Hello,

pretty new to power automate and i build a flow that when an excel file is added to sharepoint to take the file create a tabel in the file and take the rows from that file and input it into a table another excel file.

everything works untill the data needs to be added to de destination table. it only fills in 1 blank row and no data.

this is my current flow:

2023-11-10 11_19_07-Edit your flow _ Power Automate.png

so i sort of figured out that i need to input some dynamic content over here:

2023-11-10 11_21_26-Edit your flow _ Power Automate.png

But i don't know what i need to enter.

Thanks in advance for all your help and suggestions!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Bmutsinzi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @DB15
The empty spaces that need to fill are from the table that you are trying to add the row in, in your screenshot I can see it is table 1, so you can use the exact dynamic content of the information that you want to see in the table, or you can populate it manually if the information in those rows is constant on every trigger

Was this reply helpful? Yes No
DB15 7 on at

Like (0)

Report
Copy link

Link copied!

Hi, this is the dynamic content i can acces and i've tried multiple of them but i don't seem to get the right one. Which one should i use?

Thank you!

Was this reply helpful? Yes No
Bmutsinzi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you also show the table 1 screenshot

Was this reply helpful? Yes No
DB15 7 on at

Like (0)

Report
Copy link

Link copied!

Do you mean this one?
or a screenshot of the table in Excel?

Was this reply helpful? Yes No
Bmutsinzi Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Yes, please the one from Excel.

Was this reply helpful? Yes No
DB15 7 on at

Like (0)

Report
Copy link

Link copied!

These are the first few columns of 67 in total. I had to fill in some different data cause i cant share it but all rows are different.

thanks!

Was this reply helpful? Yes No