Answered

Flow to Email users based on Sharepoint List Column Value.

Like (0) Share

Report

Posted on 30 Aug 2022 16:18:22 by vSmithyyy

Hi All,

So basically we have a Inventory system using Sharepoint List and it works great for what it is needed for but im trying to help with Admin time.

Im looking to Power Automate to Scan to the Sharepoint list and if a particular "Entry" in this List and its Value in Column A (Device Location) & Column B (Device Status) = XXXX location & XXXX Device Status = a "Certain Value / String" then if these 2 "conditions are met" for an entry then send an email to XXXXXX etc.

Flow Currently:

I have tried setting the "limit Columns by view" shown below to the "True Names" of the List Columns i want it to look at but no matter what i do the flow works perfect but it tells me about any changes to the Entry even they do not match the "conditions" it has met set in the flow...

Example: &Field=Location for the location in "column a"

Btw both columns are "choice" / Dropdown Menu's with pre defined things to select.
I have also saw that i may need to use this in the condition box':

@equals(triggerBody()?['Location']?['Value'],'XXXXXX Location')

But im unsure if i need to add the second column into that line or i add as 2 separate entries

Im very new to Power Automate so go easy on me!
Any Ideas?

Kind Regards

Categories:

Business Process Flows

All responses (2)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on 02 Sep 2022 at 07:54:46

Like (0)

Report

Re: Flow to Email users based on Sharepoint List Column Value.

Hi @vSmithyyy,

Do you want to filter two of your choice column --- Location and Device Status?

Based on your description, I have made a simple test for your reference.
1. In my SP list, there are two choice columns --- Location and Device Status:
2. To filter the Location is US and Device Status is Dispose, here is my flow:
3. Result screenshots:
1). When I change the first record that Device Status changes from Recycle to In use, it does not match the condition: Location is US and Device Status is Dispose.
Then the condition is false and skip to send an email.
2). When I change the first record that Device Status to Dispose, it matches the condition I set.
Then the condition is true:
And I received the email:

Best regards,
Sylvia
vSmithyyy 12 on 30 Aug 2022 at 17:13:14

Like (0)

Report

Re: Flow to Email users based on MS List Column Value.

I have Tried editing my "condition" to the following:

Expression 1 (Location:) equals(triggerBody()?['Location'], bool('Office Inbound'))
Expression 2 (Device Status:) equals(triggerBody()?['Device_x0020_Status'], bool('Tech Assessment Repurpose / Dispose'))

But i get the error below: