cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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)

 

XT2_0-1605902734745.png

XT2_1-1605902779842.png

 

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! 

1 REPLY 1
ScottShearer
Super User
Super User

@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.

 

 

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

Scott

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,257)