You’re offline. This is a read only version of the page.
Hi,
I have 2 flows in powerautomate, one takes a Microsoft form & converts it into a sharepoint list, with a unique ID.. This works perfect.
Important: My sharepoint list's unique ID is renamed to Ticket Number
My second flow looks at the sharepoint list and notifies via email when a change is made, I.E. status update.
In the subject line of the email, I want to include the unique ID number that has already been generated in the first flow. I thought I had this sorted, but I just realised today that the number continues to count upwards and no longer matches the unique ID that appears on the sharepoint list.
For example, I created a new ticket, the ID number was 106, when status update was made, the email states the ID is 189, then if the status changes again (From 'in progress' to 'completed' it will then be 190, rather than picking up 109 and sticking with that ID number.
Would be really grateful for any help here.
The flow is designed to look at a sharpoint list item. It asks if the column 'status' has changed.
I have a condition that asks if a change has been made, true or false. - If no, the flow terminates, if yes it continues to a switch. The switch only looks at 2 status varients, either 'completed' or 'in progress', although we have more status options, we only want to send an email if one of the 2 status's are avtivated.
In case 1, status = completed then 'Send email'.
In case 2, status = in progress then 'send email'.
Ok, triggerOutputs()?['body/ID'] is exactly what you should have, so we have one more option left ...
can you tell me how you are modifying you element, because the trigger will work for both created or modified. Are you 100% sure that you are not creating a new element instead of just updating it?
I have just copied and pasted the tag from the 'get changes connector' & also double checked by hovering over the tag. Both tags show as triggerOutputs()?['body/ID']
Even after copying and pasting the tag and re-running the flow, the two ID's still do not match. The screenshot below shows that the same ticket should be 112, instead the flow test came back as 196
Ignore the ticket at 11:23 - This is a ticket that is sent to the user. For now I have removed the ID element until it is fixed.
Ok, are you sure that the ID that you pass in the email is the same as the id you pass in your "Get changes ..." conector ? You can copy paste it to be sure.
Hi Zacharie,
This is the flow before the screenshot above.
Thank you for your help
Hello @Greenybfc ,
Could you share with us the rest of the flow ?
It should work so maybe you'r not getting the right output from the right sharepoint connector.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (