Unanswered

Send an email When an item in a SharePoint list is modified based on the value of an item changed

(1) Share

Report

Posted on by AT_AlanTse123

181

Hi all, i am trying to create power automate flow to send an email when an item in a Sharepoint list is modified based on item value changed.

For example, i had the column in the SharePoint List called "Cable left". If the value of "Cable left" changed, it will send an email.

I found that Microsoft provided the template for the captioned subject but how can i set the condition that if value of "Cable left" increase or decrease, it will send email?

Would anyone can help me?

Thank you very much.

Sorry for my poor english.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

Sundeep_Malik 6,484 on at

Like (1)

Report

Hey @AT_AlanTse123

Not sure how we can determine if the value increased or decreased. But by using the action called send http request to sharepoint you will be able to get the previous value. You already have the current value. So, by this you can automatically know if it increased or decreased. Or maybe send both values in the email.

Giving you a link how you can do the above:

https://www.sharepointsiren.com/2021/05/power-automate-sharepoint-get-column-changes/
https://www.youtube.com/watch?v=DT6BpixFbHY

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Thank you very much for your information.

I tried and refer the link to create the flow and tested not work, it showed the error:
The length of the URL for this request exceeds the configured maxUrlLength value.

And it showed the error is on the third block ("Send an HTTP request to Sharepoint").

I don't know how to change Uri.

Would you please help me?

Thank you.
Below is the flow:

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

Hey @AT_AlanTse123

Nice work till now.
The place where you made a mistake is,
in the uri, in the versions, just pass the since version dynamic field dont pass the body.
Body contains everything of that item, but since version will only have the since version for that item.

Now it should work.

Just paste this in expressions after versions:
outputs(‘Get_changes_for_an_item_or_a_file_(properties_only)’)?[‘body/SinceVersionId’]

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Thank you for your reply.

I try to refer your suggestion to update the uri and run again.
It showed the error:
Cannot find resource for the request version.
but i had enable versioning

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

@AT_AlanTse123

I edited my above comment to paste this expression after versions:
outputs(‘Get_changes_for_an_item_or_a_file_(properties_only)’)?[‘body/SinceVersionId’]
Did you do that? still getting error, if yes, send the ss of both the flow in edit mode and the error in run history.

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

I do that but still has error : bad request , below is the flow in edit mode:
Error message

Thank you very much.

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,484 on at

Like (1)

Report

@AT_AlanTse123

Oh saw the mistake:

I just tried it on my end and it worked. You have directly written the expression. Do something like this:

Just paste the following directly in your uri:
_api/web/lists/getByTitle('CLPeS Cable Store')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})

Hopefully it works this time.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

@AT_AlanTse123

But when I tried this, I noticed something. It will only give you a true or false value for the column changed. It will not tell you the previous value. 😞
So, you will not be able to determine it increased or decreased.

Edited:
It gave I was using it incorrectly. Haha.

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (1)

Report

It is worked, thank you very much for your help.

Ok, it is not be able to determine it increased or decreased
That's the way it is

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

@AT_AlanTse123

After this use Get item action. Then take the column for which the value has changed. Then just find the difference between them. Something like this:

Was this reply helpful? Yes No