Answered

Power Flow trigger when a specific column changes

(0) Share

Report

Posted on by DWD76

Please help.

I have an app that is entering form data into a custom data entity in Dataverse. There is a flow that I need to trigger when a specific column is set to 'Yes' This is a choice column not a Yes/No column. However I have tried using Select Rows/Filters and tried a couple of different expressions like

@equals(triggerBody()?['crf80_Resubmit_For_Approval']?['Value'],'Yes') but nothing triggers. Anyone able to make this work when a specified column has a specified value?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DWD76

To make a flow trigger on a specific column you need to use OData expression on your Row Filter so it should look like:

crf80_Resubmit_For_Approval eq true

Was this reply helpful? Yes No
DWD76 37 on at

Like (0)

Report
Copy link

Link copied!

Since I'm not using a Yes/No type column and a Custom Choice column does it have to have "true" or would it need to be "Yes" which is the choice I want to trigger on?

In other words should it be like this? crf80_Resubmit_For_Approval eq 'Yes'

Was this reply helpful? Yes No
DWD76 37 on at

Like (0)

Report
Copy link

Link copied!

Here is a screenshot of what I am trying. This works when crf_resubmit_for_approval is modified, however, I ONLY want this to work when the value is set to 'Yes' . I tried setting the filter rows several different ways using the display name, the crf80..... name. everything I try to enter does not work.

Here is the actual field in my custom dataverse entity.

Was this reply helpful? Yes No
Verified answer

Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @DWD76

You can follow the below steps

1. Navigate to https://make.powerapps.com

2. Expand Dataverse --> Select Table --> Open your table

3. Click Columns and Open the Column crf80_resubmit_for_approval --> Click Edit Choices --> You will see your options there (yes,no) now select Yes and Copy the value (eg) 1,00,000 (remove comma and copy it as 100000)

4. Now in Filter Rows use crf80_resubmit_for_approval eq 1000000

That's it 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
DWD76 37 on at

Like (1)

Report
Copy link

Link copied!

@rampprakash

Thanks man.....using the value assigned to the choices rather than the clear display text seemed to do the trick.

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

Like (0)

Report
Copy link

Link copied!

I have the a related question. What if the column type is not a lookup field or choices but rather just text input?
What I'm trying to do is send a mail whenever the Email column gets modified.
Any way I could accomplish that????

Thanks in advance!

Was this reply helpful? Yes No
Rolson1 45 on at

Like (0)

Report
Copy link

Link copied!

Did you get an answer to this?

Was this reply helpful? Yes No