Re: Create Scheduled Excel File and Add (Filtered) Rows from an existing file.
My apologies. The details I wrote down seemed to be confusing. My problem wasn't the columns, but rather the filtering of the rows to be copied to the "Create file" action.
I did set the same column range on the "Create table" action.
There is also no available selection for *Table in the 'add rows action' if a file where I would add rows was created within the same flow. This is why I had to use a custom value.
As for the row action, I did use your recommendation.
After a day or two I did find a solution to my problem. Here's what I did:
1. Following the same flow, I added another "Filter Array" (top one) linked to the "Get tables" action.
2. "Filter array 2" was still used to filter the rows based on their Location.
3. On "Apply to each", I selected the 'body' Dynamic Content of "Filter array 2" as output from previous step. For context, "Filter array 2" is linked to the "List rows present in a table" where I will be copying data from. (not shown on screenshot)
4. Then still used the custom value on the *Table
Result: A new file is created with the expected columns containing an exact number of rows based on the filtered location.
I really do appreciate the feedback! Thank you.
