Power Platform Community Forum Thread Details

I've struggled for days to create a fairly simple flow to check if a daily SharePoint list is updated every night has been completed, and if all flight simulators have passed the nightly preflight. Basically I need the Power Automate Flow to run a daily recurrence flow, Get It
ems that will query the info SP list and check to ensure all simulators were complete.

The problem I'm having is using the Apply to each action to capture "SIM ID" that are NOT on the report and send an email about those missing preflights. Each time I do Condition to find if a "Simulator ID" that may be missing the Flow will send emails for all the value / IDs instead of just the one ID. I need a Flow that will check each value ID / Sim ID in an array and tell me if any of the Sim IDs are missing ( 0 thru 24)

{"@odata.etag":"\"1\"","ItemInternalId":"84087", "ID":84087,

{"body": {"value": [ {"@odata.etag":"\"1\"","ItemInternalId":"84087", "ID":84087, "Title":"Preflight", "SIM": {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id":23,"Value":"TD12 -- B757 FPT (XXX)"}, "SIM#Id":23,"Expires":"2023-05-06T07:11:00Z", "Technician":"XX","Date":"2023-05-05T07:11:00Z","XXX_ID":"XXX"," "{Name}":"Preflight","{FilenameWithExtension}":"Preflight","{Path}":"

Here is what I have so far, which isn't working as it sending me every Condition "false" Expression result!