Power Platform Community Forum Thread Details

Hi all,

I've built a schedule flow which will run each week to produce 3 files for manual analysis - with each file containing a particular set of items from a SharePoint List.

I've managed to build the flow that uses nested conditions whereby it:

Gets the items for the first file and generates if anything meets the criteria
Uses a fresh Get items with a new filter for the next file and generates a file if anything meets the criteria
Uses a 3rd fresh Get items with another filter for the final file and generates a file if anything meets the criteria
Sends an e-mail to a group of users who need the files for their analysis attaching the files that were generated.

On testing, however, the first file contains all the items I require, but the subsequent two files contain the exact opposite of the items I was expecting.

I thought I may have got my ODATA Filters the wrong way around in the respective Get Items, so swapped them around and tested the flow again, but it generated the exact same.

I thought it may be caused by the file 2 and 3 Get Items are nested in conditions from the first Get Items that it may be restricting to only the original Get Items, but the other files are including some items that aren't on that first file (correctly).

I've also checked that the Select and Create File steps are using the correct respective Get Items.

Any ideas welcome!