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?
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:
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.
I want to update a existing line item in SP. Should i be using Create Item or Update item?
Yes Please , and UserEmailAddress to capture the email address of the user.
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?
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
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?
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
If this helps , please give this a thumbs up and mark this as a solution.
Thanks,
Sanmesh
rpersad
16
David_MA
10
Super User 2025 Season 1
Michael E. Gernaey
8
Super User 2025 Season 1