Unanswered

Grabbing a unique ID from a sharepoint list

(0) Share

Report

Posted on by CU12081541-1

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.

2023-07-03 16_42_12-Edit your flow _ Power Automate.png

2023-07-03 16_47_55-JURA UK - IT - IT tracker - All Items.png

2023-07-03 16_48_36-Inbox-Mark.Green@jura.com - Outlook.png

2023-07-03 16_42_12-Edit your flow _ Power Automate.png

2023-07-03 16_47_55-JURA UK - IT - IT tracker - All Items.png

2023-07-03 16_48_36-Inbox-Mark.Green@jura.com - Outlook.png

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU12081541-1 on at

Like (0)

Report
Copy link

Link copied!

Hi Zacharie,

This is the flow before the screenshot above.

Thank you for your help

Was this reply helpful? Yes No
Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU12081541-1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
CU12081541-1 on at

Like (0)

Report
Copy link

Link copied!

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'.

Was this reply helpful? Yes No