I have a flow to read rows from a google sheets. I need to filter the rows based on a column value in the sheet (where the column named "appended" is empty).
I can successfully apply a filter. And I was successful appending ALL rows to SQL server - but I was not successful appending ONLY the filtered rows.
I tried many ways but Power Automate keeps is not cooperating. It keeps adding in more "apply to each"'s and then the data is added many times.
How can I use filtered data from google Sheets (not excel) to insert in to SQL.Body is coming from Get rows and not from Filter array
Hi @kellykln ,
You should not use the dynamic content from 'Get Rows' action in 'Insert row' action.
In other words, you should use the outpus of 'Filter array' action.
If you have an array and it has a column named Test, you should use items('Apply_to_each_4')?['Test'] to get its value.
Best Regards,
Wearsky