Answered

Trigger Conditions doesn't work

(0) Share

Report

Posted on by awairkar

Hi,

I have a sharepoint list which has a date field "Report Sent On" (yes....with spaces). Whenever an item is created, this field is not updated immediately. This field is kept blank until the report is sent.

So whenever the field is updated a mail should be triggered with the attachment. I tried to update this formula "@not(equals(triggerBody()?['Report Sent on']?['Value'], null))" under Trigger conditions, but it goes into loop. I have derived this formula from various sources on the net... I m no master at this. Please correct if I am wrong.

Kindly help.

Regards,

Amit

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,478 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @awairkar,

I have never seen internal field names with spaces. Normally a space is replaced by _x0020_. It is very likely that the internal name is different. Can you double check in your column settings?

Btw, you could also use an empty function. In your setup that would be something like this:

@not(empty(triggerOutputs()?['body/ReportSenton']))

Was this reply helpful? Yes No
awairkar 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus ,
I changed my field name to Reportsenton in the Sharepoint. I copy-pasted your formula in the Trigger Conditions, but again it is going into a loop after running.

Was this reply helpful? Yes No
Expiscornovus 33,478 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @awairkar,

Can you share a screenshot of the rest of your flow setup?

I have read the opening post again. Now realizing that for your requirement only a trigger condition would not be sufficient, sorry about that 😀

Every item which has a report value would trigger this flow when it is being modified. The trigger condition doesn't now if the value has been changed. It only checks what the value is (or to rephrase that, that the trigger condition expression result is equal to true).

Within the flow you could use a Get changes for an item or a file to check if the field value actually changed from null to a date value.

Also you need to take into account that whenever you update the item itself within the flow you can trigger a new flow instance. Which would explain the loop.

Was this reply helpful? Yes No
awairkar 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus ,

ohhh boy.... I thot a trigger could do the magic. Can u plz share a link or so which could b of a similar scenario?

Thanks in advance.

Regards,

Amit

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,478 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @awairkar,

Can you share a screenshot of your current configuration? This way I can adapt the example to your setup.

Btw, I was talking about something like below.

This example works with versioning (make sure that this is enabled on your list). In this example we will check if the value of the ReportSentOn field has changed. If so, you could execute the actions you want in the If Yes section.

1. Add Get changes for an item or a file action to your flow setup. Use the following expression in Since field:

add(int(triggerOutputs()?['body/{VersionNumber}']),-1)

2. Add a Condition action. Use the Has Column Changed: Report Sent on dynamic content field and make sure it is equal to true.

Was this reply helpful? Yes No
awairkar 16 on at

Like (1)

Report
Copy link

Link copied!

Sorry for the delay. It worked. Thanks for the guidance @Expiscornovus

Was this reply helpful? Yes No