cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nettsales
Regular Visitor

Have I got the correct names in these fields to filter on the Contacts table?

I have a seemingly very simple requirement to initiate a flow when a column 'ihm_webform_name' is updated.  The image shows what I have done so far but this triggers every time the record is update regardless of whether there is data in the 'ihm_webform_name' field or not.

Nettsales_0-1617868452770.png

I assume that I have the syntax wrong somewhere but not sure where.  Anyone point me in the right direction please?

1 ACCEPTED SOLUTION

Accepted Solutions
ViditGholam
Responsive Resident
Responsive Resident

To take it futher i.e null check as you don't want your filed to be empty do as below

ViditGholam_0-1617890405497.png

it will trigger only if the job title is edited.

to take it more further null check it like this 

ViditGholam_1-1617890697196.png

and put the rest of your logic inside "if Yes"

 

How to write the empty expression  

empty(triggerOutputs()?['body/jobtitle'])
 
User dynamic contents - > Expressions -> type "Empty(Click your mouse in this bracket -> go to dynamic contents and select your field name  )" you will get the equivalent condition i.e.(empty(triggerOutputs()?['body/jobtitle'])) for your field.

View solution in original post

7 REPLIES 7
ViditGholam
Responsive Resident
Responsive Resident

hi @Nettsales you can try this out 

ViditGholam_1-1617869218935.png

ViditGholam_2-1617869257442.png

i haved the trigger body according to my requirement for me the field is an option set and can be true or false 

@equals(triggerbody()?['cf_submitorderflag'],true)

 

Note : I have observed many a time the flow to misbehave when the scope is Organization may be that might be because of security roles for the users or owner of your record so run the flow with scope as Business unit instead 

 

Let me know incase of any Issues.

If this resolves your issue please mark this post as answered and hit me a thumps up.

Thanks and Regards,

 Vidit

 

ViditGholam
Responsive Resident
Responsive Resident

Also @Nettsales Don't add the row filter and try just with the column filter it worked for me when i tried in my trail

Nettsales
Regular Visitor

thanks @ViditGholam - Trying to write the equivalent of your trigger condtion

@equals(triggerbody()?['cf_submitorderflag'],true)

For my requirements I want to say that field ihm_webform_name contains data, ie is not Null.

So should this be @equals(triggerbody()?['ihm_webform_name'],Null)

I'm very new to Flow, as you can tell, so if you could help be get this expession correct, that would be great?

ViditGholam
Responsive Resident
Responsive Resident

hi @Nettsales in this case just add your field name in the column filter 

no need to write any expression your flow will only run if the user has edited the column filter field

ViditGholam
Responsive Resident
Responsive Resident

To take it futher i.e null check as you don't want your filed to be empty do as below

ViditGholam_0-1617890405497.png

it will trigger only if the job title is edited.

to take it more further null check it like this 

ViditGholam_1-1617890697196.png

and put the rest of your logic inside "if Yes"

 

How to write the empty expression  

empty(triggerOutputs()?['body/jobtitle'])
 
User dynamic contents - > Expressions -> type "Empty(Click your mouse in this bracket -> go to dynamic contents and select your field name  )" you will get the equivalent condition i.e.(empty(triggerOutputs()?['body/jobtitle'])) for your field.

View solution in original post

Nettsales
Regular Visitor

@ViditGholamthank you!  brilliant help!

ViditGholam
Responsive Resident
Responsive Resident

No Problem @Nettsales Always Happy to Help.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,730)