web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need help sending surv...
Power Automate
Unanswered

Need help sending survey forms via email when status of list object is changed in SharePoint.

(0) ShareShare
ReportReport
Posted on by 2

We created a ticketing system in SharePoint online. When users complete a form it is then uploaded to SharePoint and all data is inputted into a list format. What I am trying to achieve is when an IT member set the status to complete in the SharePoint list then it will send the user who submitted the ticket a survey form automatically. 

Can this be done?

Categories:
  • grantjenkins Profile Picture
    11,063 Moderator on at

    Hopefully this is what you're looking for.

     

    For this example, I've used the following list that just has the Title of the ticket, Person field for the person that submitted the ticket, and a Choice field for the Status.

    grantjenkins_0-1675855976839.png

     

    See full flow below. I'll go into each of the actions.

    grantjenkins_2-1675856098190.png

     

    When an item is created or modified is used as the Trigger for my Tickets list. I've also set a Trigger Condition so it will only run when the Status is set to Completed.

    grantjenkins_3-1675856173168.png

     

    The Trigger Condition is below. You would need to use the name of your Choice field.

    @equals(triggerOutputs()?['body/Status/Value'], 'Completed')

    grantjenkins_4-1675856202598.png

    grantjenkins_5-1675856261901.png

     

    Get changes for an item or a file (properties only) will retrieve the last version of the item and tell us which fields have been modified.

    grantjenkins_6-1675856346371.png

     

    Our Condition will need to cater for existing items that have been changed, and new items that have been created. The first condition checks if our Status column has changed (for existing items). The second condition checks if the item is new (doesn't have any version history - Version Number is equal to 1.0). If either condition is true, then we send the email to the user.

     

    grantjenkins_7-1675856563330.png

     

    The expressions used are:

    //First condition
    true
    
    //Second condition
    float(triggerOutputs()?['body/{VersionNumber}'])

    grantjenkins_8-1675856592708.png

     

    If our Condition action returns true, we go into the Yes branch and Send an email with the link to the Survey. You can use the Hyperlink icon to insert a hyperlink to your Survey.

    grantjenkins_10-1675856812659.png


    ----------------------------------------------------------------------
    If I've answered your question, please mark the post as Solved.
    If you like my response, please consider giving it a Thumbs Up.

  • GOTDragon1 Profile Picture
    2 on at

    Thank you for everything. I have one question. I do not see my column submitted by in power automated. 

    GOTDragon1_0-1676043542920.png

    GOTDragon1_1-1676043610078.png

     

    And I tried using the Boolean but it didn't work kept getting the error 

    GOTDragon1_2-1676043643602.png

     

     

    So how can I have it set up to where when the user submits the ticket it 

    GOTDragon1_3-1676044022882.pngGOTDragon1_4-1676044046944.png

     

  • grantjenkins Profile Picture
    11,063 Moderator on at

    It looks like you may have initially had a column called Issue Logged By when you first created your flow. Then removed that column and created one called Submitted By.

     

    In this case, you would need to refresh the schema, so it picks up the changes appropriately. To do this, Save your flow, Close the flow, then go back into Edit mode and see if the Submitted By column now shows.

     

    You might also want to delete one of the duplicate Submitted By / Submitted by columns in your list.

    grantjenkins_0-1676077553708.png

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 355

#2
11manish Profile Picture

11manish 336 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard