web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create Daily SharePoin...
Power Automate
Unanswered

Create Daily SharePoint List Tracker and send email?

(0) ShareShare
ReportReport
Posted on by

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!

Prflt1.png

 

Prflt2.png

 

Prflt3.png

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard