Skip to main content

Notifications

Power Automate - General Discussion
Answered

Flow to email all users on a SharePoint list then log the replies on a new list

(1) ShareShare
ReportReport
Posted on by 72

I have no experience with flows as I have only created power apps in the past. but am looking to create a flow activated from my app that will:

 

Pull all emails in a column on a share point list and will send a email to each email with a yes/no box (or something similar)

 

If user says yes, nothing happens 

If user says no, writes there email + date to a different SharePoint list, then deletes the row with there email in on the 1st list 

 

any advice on how to do this or at least start this off would be massively appreciated 

Sam

 

  • SamSellars Profile Picture
    SamSellars 72 on at
    Re: Flow to email all users on a SharePoint list then log the replies on a new list

    Thanks so much @v-chengfen-msft everything works and your guide was perfect

     

    Sam

     

  • Verified answer
    Re: Flow to email all users on a SharePoint list then log the replies on a new list

    Hi @SamSellars 

    You could select Yes in Send email with options-Use only HTML message, so that you can only put a place in the display of the mail on the web.

    vchengfenmsft_0-1677461099503.png

     

    Best Regards

    Cheng Feng

     

  • SamSellars Profile Picture
    SamSellars 72 on at
    Re: Flow to email all users on a SharePoint list then log the replies on a new list

    Thankyou so much @v-chengfen-msft,

     

    That worked perfectly the only thing is is it possible to only have the email show the message once?

     

    SamSellars_0-1677157408765.png

    as currently it has the same information twice and I only want the top box and remove everything on the email from Request for your input

     

    Thanks Sam

     

  • Re: Flow to email all users on a SharePoint list then log the replies on a new list

    Hi @SamSellars ,

    I made a template for your reference

    Here are sharepoint lists:

    vchengfenmsft_4-1677118399273.png

    vchengfenmsft_9-1677118618738.png

    In flow

    vchengfenmsft_3-1677118380562.png

    vchengfenmsft_7-1677118535606.png

     

    vchengfenmsft_6-1677118478272.png

     

    vchengfenmsft_8-1677118560864.png

     

    In power apps

     

    vchengfenmsft_0-1677118247119.pngvchengfenmsft_1-1677118266245.pngvchengfenmsft_2-1677118286416.png

    Here is result:

     

    vchengfenmsft_10-1677118711202.pngvchengfenmsft_11-1677118729061.png

    vchengfenmsft_12-1677118752038.png

     

    vchengfenmsft_15-1677118862122.png

     

    vchengfenmsft_14-1677118849194.png

     

    Best Regards

    Cheng Feng

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard