Help adding a row to an excel table

Eileen Wallwork · August 5

Whenever I add the step 'Add a row into a table' Power Automate throws it into a loop (see below). I did not add the section 'Apply to each 3'. Do you know how I can stop it from looping? I am not sure what to add for 'Select an output from previous steps'.

The table is created and I can see it is the shared drive. I am trying to add 1 row of data.

Thank you for your help! Eileen

Alex Wong · August 5

PA throw your action into an Apply to each whenever, you are using dynamic content that is in an array (i.e. gift date from a gift list array).

So the question starts with, what are you trying to add using Add a row into a table, what dynamic content you were adding?

Eileen Wallwork · August 5

We print some acknowledgement letters in house, and outsource the others. I followed a template provided in this community and successfully automated creating the letters to print in house. To that flow, I added a condition that if the letter code = A, B or C, then send to an excel file in SharePoint that we will send the print company. I think the issue is the Acknowledgement Letter and Acknowledgement Status. I am ignoring acknowledgement status for now… I created a variable called Acknowledgement and set it to the Acknowledgement Letter from the source data. That seems to have fixed the issue. So I assume I need to do the same for Acknowledgement Status. Is this because the source data is a table? I don't get why I need to do this for these fields and not others.

It is kinda working now. I successfully added 1 row of data to the excel file but then the flow fails. I am thinking I need to adjust it and add an append to add other rows to the table and not create a table each time.

Alex Wong · August 5

Acknowledgement is an array (list of multiple acknowledgements), which is weirdly done by Blackbaud.

ONE gift meant to only have ONE acknowledgement record, but since it is an array, it causes issue with Apply to each.

One way to fix this is to use the first() expression to get the first record in the acknowledgement array, then target the property you trying to get (i.e. status). or you can use a parse json action, and the source is first() element of the acknowledgement record, then you can use the dynamic content (i.e. status) from the parse json action more user friendly-ly.

Eileen Wallwork · August 5

@Alex Wong Thank you Alex, that is very helpful! I was watching a video on how to use first() expression to get the first record. I'll try that now. I appreciate your help!

Help adding a row to an excel table

Answers

Categories