Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iH2spEUfpueNQx6iaS770w
Power Apps - Microsoft Dataverse
Answered

Dataflow Triggering "Modified" Automation

Like (1) ShareShare
ReportReport
Posted on 26 Jan 2023 18:55:29 by 14

I have a flow that is setup to trigger when a column is modified on a dataverse table. 

Screenshot 2023-01-26 105104.png

 

I also have a dataflow that updates this table daily, issue I am having is that the dataflow is triggering the automation every time it runs on every line even when the specified column does not change. Is there a way to avoid this?

  • Verified answer
    AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on 30 Jan 2023 at 13:59:16
    Re: Dataflow Triggering "Modified" Automation

    @rampprakash, I though about the same thing after I posted my reply. I think yes/no wont work. It has to be a time stamp. and you check the time to be within a range where the dataflow run. 

  • Ram Prakash Profile Picture
    5,166 Super User 2025 Season 1 on 30 Jan 2023 at 06:07:38
    Re: Dataflow Triggering "Modified" Automation

    Hi @AhmedSalih 

     

    But am having another doubt too if we set that field to Yes then while making changes again in the form and we expect the flow to trigger at that time it won't trigger.

     

     

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on 28 Jan 2023 at 15:38:21
    Re: Dataflow Triggering "Modified" Automation

    Hello, @mschwing, Dataflows update all columns values with the data from the datasource regardless of whether the data changed or not. 

     

    One way I use to achieve your requirement is add a column to hold the change status of your 
    specified column". This will be yes/no column. In your data source, where you are pulling data using the data flow, you will need to change the value of this column to yes when that column change. 

     

    Note, you need to have this status column in the dataverse table too and map it in the dataflow. 

     

    Now, in your power automate you need to setup your trigger as below: 

    AhmedSalih_0-1674920286747.png

     

     

    If my reply helped you, please give a đź‘Ť , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#2
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#3
CU07050602-0 Profile Picture

CU07050602-0 4

Overall leaderboard

Featured topics

Loading complete