You’re offline. This is a read only version of the page.
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?
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.
Thank you for everything. I have one question. I do not see my column submitted by in power automated.
And I tried using the Boolean but it didn't work kept getting the error
So how can I have it set up to where when the user submits the ticket it
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.
See full flow below. I'll go into each of the actions.
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.
The Trigger Condition is below. You would need to use the name of your Choice field.
Share
Report
All responses (
Answers (
@equals(triggerOutputs()?['body/Status/Value'], 'Completed')
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.
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.
The expressions used are:
//First condition
true
//Second condition
float(triggerOutputs()?['body/{VersionNumber}'])
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.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
