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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (60,539)