Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

trigger when a user deactivates a record

(0) ShareShare
ReportReport
Posted on by 108

I want a PowerAutomate flow to kick in when a user selects a record from a PowerApps Model Driven app and deactivates it.   Surprisingly, that action is not captured by https://docs.microsoft.com/en-us/power-automate/dataverse/create-update-delete-trigger

 

Why is "deactivating a record" not regarded as update?

 

 

Categories:
  • EricRegnier Profile Picture
    EricRegnier 8,705 on at
    Re: trigger when a user deactivates a record

    Hi @bs-dev001,

    To add to the previous posts, yes a deactivate and activate is regarded as an update. But to do you want to trigger a flow when a user selects a record? If so you'll need to use the legacy Dataverse connector not the current environment and use the trigger "when a row is selected": https://docs.microsoft.com/connectors/commondataservice/#when-a-row-is-selected 

    Hope this helps!

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,273 on at
    Re: trigger when a user deactivates a record

    Hi @bs-dev001 ,

    To extend on @rampprakash answer, you can also use the Filter rows to have:

    statecode eq 1 

    Which will trigger specifically when the record is inactivated...  (https://docs.microsoft.com/en-us/powerapps/developer/data-platform/entity-metadata#table-states)

     

  • Verified answer
    Ram Prakash Profile Picture
    Ram Prakash 5,154 on at
    Re: trigger when a user deactivates a record

    Hello @bs-dev001

     

    Try creating a flow with SELECT COLUMN as statecode

     

    rampprakash_0-1642151978079.png

     

     

    If we input statecode in SELECT COLUMNS the flow will only trigger if any status chagned

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics