Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Send an Email depending on status from a different list

Dear all,

I have 2 SharePoint lists and I want to create a flow that runs every day.

The first list is the appointment List (Termine) and the second is the Devices List (Geräte).

Νοw the appointment list has to do with rollout appointments and the devices with the devices that the technician is checking per day on these appointments.

Now what I want to do is to create a flow that runs every day and checks

1.From all Items of the appointment list I need only those that have in the Termin_Status Column the value "Vereinbart"

2.Then I need to check the date if they are already old, more than 5 days old

3. If those conditions are valid then I need to compare the column Gerät(look up from the title of the devices list which has the number of the device written inside as text) 

4.If they much then I need to check the Hardware_Status Column of the second list (devices) and 

5. If the status is NOT equal to Choice 1 and Choice 2 then

6. I need to send an Email to the technician (there is a peoplepicker column in both lists for him) that he forgot to change the status of that device(s)





If anyone has an idea how I can do that or even if it worth the trouble, or even an alternative, please let me know! 

Super User III
Super User III


Here is some information to get you started.

You'll want to use a Recurrence trigger - it can be confogured to run once a day.

To retrieve items from a list that meet certain criteria, you'll want to use a Get items action along with an OData filter.  Here is a link for a great blog post on using OData filters with SharePoint and Flow. 

My suggestion is to get started with the information above and post any questions that you have along the way here.



If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (17,280)