HAS COLUMN CHANGED ISSUE in POWER AUTOMATE

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a sharepoint list,

Basically, I've set it to email certain people when certain column have certain values in Power Automate

For instance, my column is a choice filed: (with 5 options)

If want power automate to trigger an email to a specific email address if;

option 1 is selected (email A)

option 2 is selected (email B)

etc.

I have a choice column in SharePoint which contain 5 items list (Await QC Action, Await Credit Action, etc)

I want the power Automate to send a mail when the status changes base on the value i included in the screenshot.

if the column have changed to "Await QA Action" it should send a mail to acb@y.com

if the column have changed to "Await Credit Action" it should send a mail xyz@a.com

for every item in the choice column, it should send a mail to the owner of the action.

How do i active that?

In below screenshot, I have set the "choose a value" to "Await QC action",

below is my screenshot

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Shujaath_Khan @Hardesh15 @vivekpande18 @ScottShearer @Shuvam-rpa

Please assist

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What is your question? What do you need assistance with? Everything you've said above is a statement about what you are doing, and it is a valid method - a condition, identify if true, send email.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Rhiassuring

I have a choice column in SharePoint which contain 5 items list (Await QC Action, Await Credit Action, etc)

I want the power Automate to send a mail when the status changes base on the value i included in the screenshot.

if the column have changed to "Await QA Action" it should send a mail to acb@y.com

if the column have changed to "Await Credit Action" it should send a mail xyz@a.com

for every item in the choice column, it should send a mail to the owner of the action.

How do i achieve that?

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You could use a "Switch" action which evaluates your column.
I would then, in each Switch branch, set a "txtEmail" variable to the appropriate email.
Then, on the outside of the switch, I would create an email, and send it "To" the txtEmail variable, which will now be the appropriate email.

Here is a great article by Manuel T Gomes about the Switch action:

https://manueltgomes.com/reference/power-automate-action-reference/switch-action/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Rhiassuring , the article is helpful and i followed the steps.

However none of the mail dropped. below is my screenshot

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

The "Has column changed" value will only return "true" or "false". It will not return the value of the column. You need to use the initial trigger values to check the state.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am new to Power Automate, Can you show me how please? or a related article

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,692 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

1. Flow triggered on change.
2. Initialize a string variable called 'txtEmail'
3. Use the "Get changes for an item or file" action.
4. Evaluate if the specific column you're looking for has changed (let's pretend it's the "Status" column) by using a condition and "If column has changed: status" equals true. On the "No" side, terminate the WF. On the "Yes" side, enter a switch.
5. The switch should point at the dynamic content from your very first trigger, the "When sharepoint item has been modified", and then your "Status" value.
6. Type each potential status value exactly for each branch. There can be no difference in space or capitalization, it must be exact.
7. In each state, use the "Set Variable" action to set the "txtEmail" variable to the appropriate email for that specific status.
8. On the outside of the states, underneath, the very bottom, create an email and put 'txtEmail' in the To field.

Ends up looking like this:

Close up of switch:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I did try it, but still not working, i guess maybe because i dont know much about power automate.

Can you share the file used for the above?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It worked when i made changes to the SharePoint, but when an item is newly created is doesn't work

Was this reply helpful? Yes No