Skip to main content

Notifications

Power Automate - Building Flows
Answered

Trigger flow when a specific column is updated in a sharepoint list

Posted on by 177

I am new to power automate so apologies for lack of knowledge.

 

I have a sharepoint list (see screen grab) that is used to track relationships. I want to send an email to the 'Mentee' whenever anything is added (not updated) to the 'Relationship End Date' field. How do I set the flow up to trigger only under these circumstances?

 

ChrisUndery_0-1684935719227.png

 

  • SN-11111517-0 Profile Picture
    SN-11111517-0 2 on at
    Trigger flow when a specific column is updated in a sharepoint list
    I have a similar question. I have a list with several columns and I wish the flow to trigger only when the column "Status" is updated. I tried following the Verified Answer, but this might be for an older version of Power Automate? There exists a Since field, but no Unit field. How do I handle this?
  • ChrisUndery Profile Picture
    ChrisUndery 177 on at
    Re: Trigger flow when a specific column is updated in a sharepoint list
    Works a treat - Thank you
  • Verified answer
    RobElliott Profile Picture
    RobElliott 9,972 on at
    Re: Trigger flow when a specific column is updated in a sharepoint list

    Use the "when an item or a file is modified" trigger. Then add the get changes for an item or a file. In the Since field select Trigger Window Start Token and in the Until field select Trigger Window End Token. Then add a Condition and select Has Column Changed: Relationship End Date is equal to true. Add whatever actions you want in the if yes and if no channels.

     

    That won't fire when the item is added but will when it gets modified.

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard