Share
Report
20I'm trying to use Microsoft Flow to grab items in a SharePoint list and copy them into an Excel Online (Business) file every day.
I was able to copy items into an existing Excel Online (Business) sheet with a manually created Table using:
1. Schedule flow run
2. Get Items (filter query to grab items meeting the condition I want)
3. Add rows into Table
However, the items populate the bottom portion of the created Table. In other words, my created Excel table had 132 rows, but the Flow (correctly) returned 40 items and placed them at the bottom of the table (see attached).
Since the number of items returned each day will vary, how do I create a flow that creates a table then adds the appropriate number of rows based on the conditions I define?
Many thanks,
Drew
All responses (
Answers (
