Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 12

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:
  • jw_dbs Profile Picture
    12 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

    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:

    jw_dbs_1-1711416140783.png

     

     

  • SanmeshG Profile Picture
    1,938 Super User 2025 Season 1 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

    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.

  • jw_dbs Profile Picture
    12 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

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

  • SanmeshG Profile Picture
    1,938 Super User 2025 Season 1 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

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

  • jw_dbs Profile Picture
    12 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

    Do I select the below options for User Selected Option?

     

    Select Compost ->Send email with options - SelectedOption

    jw_dbs_1-1711343780523.png

    jw_dbs_0-1711343724129.png

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

  • SanmeshG Profile Picture
    1,938 Super User 2025 Season 1 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

    Hi @jw_dbs ,

     

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

     

    S1S1

     

    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

  • jw_dbs Profile Picture
    12 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

    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?

  • SanmeshG Profile Picture
    1,938 Super User 2025 Season 1 on at
    Re: Update Sharepoint list column with a button or hyperlink from an email

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard