I have a flow that has been running perfectly fine until just last week.
The flow is set up as follows:
1. Get items action which returns all items within a Sharepoint List
2. Filter results via filter action which identifies - A. that a specified column contains content, and B. That a specified column is 'Current'.
3. Resulting items are then populated into an Excel spreadsheet template
4. The spreadsheet is then copied into a location for records
5. A script is run to clear the Excel template.
My issue is that despite the flow indicating that it has picked up eligible items in the filter stage, and showing that X number of items are then being handled at the 'Add a row into a table' action, my copied excel spreadsheet displays just blank rows and none of the filtered content. I had not changed anything from the prior weeks, it just started happening.
I know the action is doing SOMETHING as the copied spreadsheet appears to have expanded rows, which i know the script at the end deletes at the end of each run - but I am not sure why the content is not populating.
If anyone has experienced this issue or knows what is going on, any help would be great! I have provided a high level image of the actions, but can provide further detail if this may be helpful.
Thank you 🙂
