Hi Everyone,
I'm struggling with an expression, its not working, and I'm not sure about the syntax at all 😞
if(not(equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'], '105 óra','70 óra','140 óra','160 óra')),'ListIf_EgyuttTartamEgyeb', ' ')
What I'm trying to do:
if the field 'ListIf_EgyuttTartamEgyeb' value is NOT ('105 óra' OR '70 óra' OR '140 óra' OR '160 óra'), then the true condition of the IF should be the value of the field 'ListIf_EgyuttTartamEgyeb', the false should be just an empty character.
Can it be done? Thanks for your help
Solved! Go to Solution.
Hi @Anonymous,
Please have a test on the following expression:
if(not(or(equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'105 óra'),equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'70 óra'),equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'140 óra'),equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'160 óra'))),triggerBody()?['ListIf_EgyuttTartamEgyeb'],'')
The structure is - if(not(or(field is equal to A, field is equal to B, field is equal to C, field is equal to D)), 'field', '')
Hope it helps.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see the following expression
@or(equals(triggerBody()?['ANSI_x0020_Status']?['Value'],'Rejected by Procurement'), equals(triggerBody()?['ANSI_x0020_Status']?['value'],'Completed'))
This expression evaluates true if either of them are correct, you will need to add a not.
basically you nee dto split them out into seperate conditions for each value and then use a not as well
Hi @Anonymous,
Please have a test on the following expression:
if(not(or(equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'105 óra'),equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'70 óra'),equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'140 óra'),equals(triggerBody()?['ListIf_EgyuttTartamEgyeb'],'160 óra'))),triggerBody()?['ListIf_EgyuttTartamEgyeb'],'')
The structure is - if(not(or(field is equal to A, field is equal to B, field is equal to C, field is equal to D)), 'field', '')
Hope it helps.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot for the syntax and for the explanation. It's perfectly working now!
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
32 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
51 | |
22 | |
12 | |
11 | |
9 |