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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

No Problem @Nettsales Always Happy to Help.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (3,288)