You’re offline. This is a read only version of the page.
Announcements
29
I'm having problems finishing off a flow to copy selected rows. What I am trying to achieve is to the copy selected rows of a table into a new worksheet that has a copy of the source table i.e. exactly the same columns headers. I've done this by adding a filter action and selecting the rows that meet the filter criteria. Easy enough.
How do I then take the selected rows from the filter and copy them to the new table? All the attempts to do this have resulted in the outputs from the filter going into the new table not the actual cell entries for the respective source table columns into the destination table columns.
When I use the add a row action there is no dynamic data from the filter array aside from outputs making it easy to distinguish which of the filtered row outputs goes into which column in the new table.
Hi @NeilNPH ,
An easy trick is using a Parse JSON action, copy and paste the output of Filter array (you can get it from a run history) to generate JSON schema, then dynamic contents from output of Parse JSON can be used in the add a row action:
If you have got deeply familiar with Power Automate expression, you can also write expressions to get desired values:
Share
Report
All responses (
Answers (
items('Apply_to_each')?['ColumnsOfFilterArray']
Anyway, you can copy outputs of Filter array from previously run history and paste to a blank Text document for a later use. You'll be able to find all column names and generate JSON schema.
Best regards,
