When sending an email, change choice column to another choice in the body

(1) Share

Report

Posted on by Charlie Martharper

842 Season of Giving Solutions 2025

Hi!

I was trying to make a mail almost like an approval but without being an approval, just with a mail, and when clicking over a "Yes" it changes the choice option to Approved in the SP column and if its clicked over the "No" it changes to "Refused".

Is it possible?

Categories:

Connector development

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

MS.Ragavendar 6,907 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Charlie Martharper,

Try with Send email with options Options and check the logics accordingly.

User Options parameter you need to provide values by comma separated.

Use condition to check and based on the condition you can update the values accordingly.

This can be also done in some other way by using When an HTTP request is received as trigger this becomes Premium. So if the users access this they also need a premium license. So i leave the choice to yours

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Charlie Martharper 842 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Perfect!

I receive the mail correctly with the options I asked but it appears twice and without spaces, like all together in one row. Look:

Now I would need, when one of the options is selected, modify the column choice with the option selected in the mail "Aprovat" or "Rebutjat". Right now it doesnt change anything I guess an action is missing.

And is it possible for the mail to be like:

Nom usuari: ...

Data Formació: ...

Hores Formació: ...

Unitat: ...

I wait for response! Thanks @MS.Ragavendar

Was this reply helpful? Yes No
Suggested answer

Kalathiya 1,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Yes, this is possible. You can use the selected option response and map it to your SharePoint choice column using an expression like this..

Expression - Put this expression in your column.
if(equals(outputs('Send_email_with_options')?['body/SelectedOption'],'Yes'),'Approved','Refused')

If you use the expression you don't need to add the condition you can handle it using Expression as best practice.

Updated Email body with options:

You can pass your email body in body text section.

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,907 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Charlie Martharper,

If Hide HTML message is set as Yes the second thing will be removed or else the screenshot which you showing is the expected behaviour.

I also shared the sample blog post which covers this scenario.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No