Update Sharepoint list column with a button or hyperlink from an email

(0) Share

Report

Posted on by jw_dbs

Is it possible to Update Sharepoint list column with a button or hyperlink from an email?

e.g Employee will receive this email when an update has been submitted via Powerapps into the Sharepoint LIst

Subject: Sharepoint List has receive a new update from XXOO. Complete this task by 10/26/24
 
You have receive the data for your update in to ABCD System.

Please click this link once you have completed the update
 <a>Click here to mark complete</a>

I want the column Status, to be updated to Completed.

Should the Status column be a choice type? It would only have one update which is Completed.

Otherwise it would be blank at the beginning i reckon.

Can we generate the hyperlink via power automate?

Or using other method with Powerapps will work better?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @jw_dbs ,

You can consider using adaptive cards for outlook. Using adaptive cards for outlook you can include actionable messages (but it makes use of a premium trigger when an trigger http request is received).

Few Links to Explore:

1. https://learn.microsoft.com/en-us/outlook/actionable-messages/adaptive-card

2. https://d365demystified.com/2020/11/23/adaptive-cards-for-outlook-actionable-messages-using-power-automate-power-platform/

If this helps , please give this a thumbs up and mark this as a solution.

Thanks,

Sanmesh

Was this reply helpful? Yes No
jw_dbs 12 on at

Like (0)

Report

What if i use Send Email with Options instead?
Where are the responses stored for Send Email with Options?

Is it possible to get the response and update it to Sharepoint?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @jw_dbs ,

Yes you can store store the responses in SP List. Please see the below steps.

S1

You will get an option to select the user response from the action send an email with option , select the userSelectedOption and create the item in SP List , you can also save users email address from the send an email with options action.

If this helps , please give this a thumbs up and mark this as a solution.

Thanks,

Sanmesh

Was this reply helpful? Yes No
jw_dbs 12 on at

Like (0)

Report

Do I select the below options for User Selected Option?

Select Compost ->Send email with options - SelectedOption
I want to update a existing line item in SP. Should i be using Create Item or Update item?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Yes Please , and UserEmailAddress to capture the email address of the user.

Was this reply helpful? Yes No
jw_dbs 12 on at

Like (0)

Report

I want to update a existing line item in SP. Should i be using Create Item or Update item?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

you have to use Update item action but now here how do you identify the List ItemId ? If only one response is allowed per user you can make use of the Get Items action filter query and pass the email from the send an email with options action , specify top count as 1 , and then use the ID from the Get Items action in Update item action.

Was this reply helpful? Yes No
jw_dbs 12 on at

Like (0)

Report

I was able to sort out the update item action. Thank you!

Now i have another question.

The flow is like this:

The first send email with options will be sent to User Edmund.
User Edmund will add additional attachments to the SP item line and select a response.

After that is completed, I would like to send an email to the 2nd User BDO and attach all attachments(including the ones Edmund added) into the email with options.

How can i do that?
I tried but the flow failed. Thank you for assisting. I am new to power automate.

This is what i did:

Was this reply helpful? Yes No