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

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (7,992)