Hi all,
I have a flow that is triggered when a SharePoint list item is edited.
The current condition is when a Yes/No column called "Added to SQL" is set to yes then the flow should trigger.
@equals(triggerBody()?['AddedtoSQL'], true)
I would like to add a second condition to avoid the flow to trigger again. This is an extract of my trigger output:
"body": {
"@odata.etag": "\"7\"",
"ItemInternalId": "67",
"ID": 67,
"AddedtoSQL": true,
"SQL": "No",
"SharePoint": "Yes",
So I would like the trigger to execute when:
1) Added to SQL is true
2) SQL is No
I had this but its not working:
@And(equals(triggerBody()?['AddedtoSQL'], true), equals(triggerBody()?['SQL'], false))
Does the condition need to be of value No or false?
Thanks,
David
Hi David,
The column 'SQL' looks like a single line of text so pls modify the trigger condition as shown below:
@and(equals(triggerBody()?['AddedtoSQL'], true), not(equals(triggerBody()?['SQL'], 'Yes')))
If 'SQL' is not single line of text then pls share its data type.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional