Modified Sharepoint List Choice Column Value Change

(0) Share

Report

Posted on by craig_01

153

Hi All,

I am building a flow to send a custom email alert when a value changes in specific column (which is a choice column).. However i am getting an error. And believe its to do with the "choice" nature of the column..

Flow is shown below,

The condiiton is based on the column which is changing, with the switch cases being based on some of the two choice which i want to know about...

This is the error i am getting after testing.

The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/TOPCOAT']' is not valid. It is of type 'Boolean' but is expected to be a value of type 'String, Integer'.

Any help would be appreciated.

Regards

Craig

All responses (4)

Answers (0)

craig_01 153 on at

Like (0)

Report

Re: Modified Sharepoint List Choice Column Value Change

Ok, i have narrowed down the cause.. On this same list i have another flow which basically either adds or updates the sharepoint list from a SQL Table... Because the "update" is running through all the records, this is then causing the notification update to get triggered..

Any suggestions on the update from SQL

Regards
Craig
craig_01 153 on at

Like (0)

Report

Re: Modified Sharepoint List Choice Column Value Change

Ok bit of an update. Im getting notifications based on the two status that i want notified about.. However i am also getting notifications from older entries that are the same status... So how do i prevent this, and ensure that the flow is only looking at changes from this point forward?

Regards
Craig
craig_01 153 on at

Like (0)

Report

Re: Modified Sharepoint List Choice Column Value Change

Hey @Caspar_Rubin thanks for the reply.. Under my first trigger "When an item or file is modified", do i need to set any Trigger Conditions under the settings for this, at present i dont have any set within this window.

Within my Get Changes for an Item or a File (Properties Only) my ID, Since, Unit are as below..
"id": "@triggerOutputs()?['body/ID']",
"since": "@triggerOutputs()?['body/{TriggerWindowStartToken}']",
"until": "@triggerOutputs()?['body/{TriggerWindowEndToken}']",

Are these correct, for what i am trying to do?

For my condition, i am using the Dynamic content, TOP COAT FINAL Value field, rather than the Boolean.?

And for my switch i am use the TOP COAT FINAL Value field, which are either DONE or PENDING as the options.

Thanks
Caspar_Rubin 830 on at

Like (0)

Report

Re: Modified Sharepoint List Choice Column Value Change

Hey,

I think you need to choose a different Switch "On" value. The "Has column changed..." only returns "true" or "false" (boolean) and not "Done" or "Pending", etc. That's from a field in your SharePoint List, right?

If i understand your logic correctly, you'll need to choose the Dynamic content value from the Status column of your trigger "When an item or a file is modified"?

cheers

Community site session details

Modified Sharepoint List Choice Column Value Change

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Modified Sharepoint List Choice Column Value Change

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates