Send an Email depending on status from a different list

[Anonymous]

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! 

[ScottShearer]

@Anonymous 

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.