Answered

Power automate to tigger my flow when When an item is created or modified

(0) Share

Report

Posted on by RV_KONDRA

Hi Guy's, i am struggling to trigger my flow when only "Assigned to" column in my share point list is changed by the user by selecting an email id from my assigned to which is a choice column.

when the change happened I am receiving the below error message.

The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created_or_modified' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnUpdatedItems' requires the property 'body/value/0/Assigned_x0020_to' to be of type 'String' but is of type 'Object'.'

Any help please?

Below is my flow

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @RV_KONDRA ,

try to create the trigger condition using the 'Filter array' action - add the action, use its GUI to define the condition, switch to advanced mode, copy/paste it as a trigger condition.

Was this reply helpful? Yes No
mahoneypat 1,720 on at

Like (0)

Report
Copy link

Link copied!

If it is a person column, you likely need this syntax (replace the red text with your column name). You can also add a compose step and choose the Assigned To Value field, and look at the peek code to see the needed syntax to use in your equals in the trigger condition.

triggerOutputs()?['body/PersonColumn/Email']

Pat

Was this reply helpful? Yes No
RV_KONDRA 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom, thanks for looking into this. I tried the below code but received the below error
@equals(triggerOutputs()?['body/Assigned to/Value'], 'rpj@PS.co.uk')

Was this reply helpful? Yes No
RV_KONDRA 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Pat, it's a choice column.

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RV_KONDRA
I did a simple test on my side and you can refer to the screenshots below.
This is my test list.
Trigger Conditions
@equals(triggerOutputs()?['body/Assignedto/Value'],'Litest@xxxxxx.com')
Note: 'Assignedto' in the above expression is the internal name of 'Assigened to' column.
You can find column internal name via List settings -> Click on the column name -> It’s at the end of the URL on the Edit column page, after ‘Field=’.

And please select 'Assigned To Value' in 'To' field of Send an email action.
Save and test again.
Best Regards.

Was this reply helpful? Yes No