cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucas_Ignatius
Helper V
Helper V

Modify on specific column SharePoint List and send email Person

I would like to create PowerAutomate for SharePoint List, but need help for problem.

How to create Flow where specific column on SharePoint List is change  and send email based on person column

Because is different date and day for user input that column.

I give my screen shoot SharePoint List for better explanation.

Recommendations or a better trigger, or how to properly configure this trigger, would be greatly appreciated

Email when modify in column spesific.png

 

6 REPLIES 6
ScottShearer
Super User
Super User

@Lucas_Ignatius 

While I don't totally understand your requirement, it will involve the use of the use of the SharePoint Get Changes for an Item or File action.  See my example below and let me know if you have additional questions.

image.png

 

 

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

Scott

I'm apologize for my question.

I mean, if someone modify only specific column (DeliveryDate Column) it will be email to person column.

because I'm using flow to input on this new list (list name : New Order POSM Processing)

flow1.jpg

 

Rule SharePoint List

Rule1.JPG

 

rule2.jpg

 

and when I'm using rule on SharePoint List it have problem :

1. make me twice times modify to make this rule works and send email

2. if send email it send one by one, so another people is didn't know who is receive email.

(Example : in person column have 3 person but only show 1 person, even though all person is receive. But to make sure is need 3 person on email)

Email.png

 


Thanks

Lucas_Ignatius
Helper V
Helper V

Can anyone help me to build this flow?

 

flaviatakushi
Community Support
Community Support

@Lucas_Ignatiusbased on description you sent I created an example of how you can configure your flow.

Please adjust the details according to your needs.

 

Details:

- Since: sub(int(triggerOutputs()?['body/{VersionNumber}']),1)

This expression will validate the last change version.

- Created a string variable to store the list of person as you would like to send email to all person at once.

- Validate if specific field (in my case is Date) was changed.

- Send email using variable created above.

 

flow1.JPG

flow2.JPG

If this works for you, please mark my answer as Solution.

Hi, I think is different with my problem.

My problem when user is change column or input new date only column PODate, ProduksiMateriDate and DeliveryDate it will be sent email to person Column.
Can you help me for this problem? 
I'm very sorry is my if my explanation is bad and not clear

flaviatakushi
Community Support
Community Support

@Lucas_Ignatius not sure if I understood well.

But if you need to run flow whenever the data is inserted into columns PODate, ProduksiMateriDate and DeliveryDate, you can just adjust the condition in the flow I shared. For example:

 

Condition:

Has column changed: PODate

OR

Has column changed: ProduksiMateriDate

OR

Has column changed: DeliveryDate

 

The rest would be the same.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,201)