Unanswered

Trigger Conditions 'When an item is created or modified' choice field

(0) Share

Report

Posted on by iK1

I a have a SP list and I am trying to add a trigger when the status is complete to send an email with the details Sharepoint fieldepoint is a choice ,column so I think what is making it more difficult. I was going to try a calculated field as single line text based on the ,status, but that did not work either.

The flow works like this the status is complete

The client name = ABC

Send email

I have tried multiple ways and different error messages

@equals(triggerOutputs()?['Status']?['Value'], 'Complete')Cannot read properties of undefined (reading 'properties')

@equals(triggerBody()?['Status']?['Value'], 'Complete')

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['value']' is of type 'Null'. The result must be a valid array.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Caspar_Rubin 831 on at

Like (1)

Report

Hey,

this works for me:

@equals(triggerBody()?['Status']?['Value'],'Completed')

My choice field has a choice of Draft or Completed.

Are you sure, the internal name of your Status column is really Status? Maybe the column has been renamed?

You can find the internal name of every column by opening the list settings

then clicking on the Column in question:
and the checking the URL Parameter after &Field=
that's the real name of the column and it never changes, even if you rename the column.

lets us know,
cheers

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Hello @iK1
you should use the following expression:

@equals(triggerOutputs()?['body/Status/Value'], 'Completed')

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
iK1 4 on at

Like (0)

Report

Thanks.. I created the flow and it worked.

Was this reply helpful? Yes No