Change Forms Response Id in Lists

[MicrosoftUser01]

I have a flow that creates a List entry and adds /21 for the year when a user fills out a form, giving me a unique ID on the list that I then use as reference when sharing. I have recently updated the form and my response Id has reset, now giving me duplicate references in my List.

Can I change the Response Id in the Create Item step to add a number to bring that Response Id back inline with the old sequential Response Id from my old form to maintain the reference number on the List.

The old List ID ended at 272/21 but the new is up to 19/21. 272 and 19 being the Response Id from the Forms entry. 

[RobElliott]

No, it's not possible to change the form response id.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[MicrosoftUser01]

@RobElliott Thank you for your response. 

I dont want to change the Form Response Id at source I am trying to change the input into the Title column of the Microsoft List. Is there no way to take the Response Id and add a fixed Integer to it? PSB for the setup:

User Fills out Form, Automate gets response details and then creates Item on the Microsoft List. For the Title field I then append /21 for this year.

Currently I have to manually change the Title column below, however if there was a function or expression I could use to add a set Integer to the current output of the Response Id then it would mitigate the manual step.

Obviously if like you said It cant be changed at the Create Item List entry stage then I will except this as solved. A manual solution I have found is just to manual input dummy Form responses until the Response Id gets to a number inline with the above.

[RobElliott]

Yes, if you are putting the response ID into a different column you could grab it, increment it by 1 then add it to the list in the Create item action.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[MicrosoftUser01]

@RobElliott 

How do I do that? Also can I add a different number such as 250 to the Response Id number?

[chandra1]

Hi @MicrosoftUser01, if you are thinking adding 21 year attaching to your list item id but want to automate instead typing manually you can use below function.

substring(body('Current_time'), 2, 2)

Let me know if it helps.

[MicrosoftUser01]

@chandra1 thank you for the above, I will try and let you know. Will make it easier when we roll into 2022 👍.

[MicrosoftUser01]

@chandra1 works well, how do I amend to output 2021 instead of just 21?

[chandra1]

Glad to know it worked.

if you want to add full year you could just replace the values as below. 

substring(body('Current_time'), 0, 4)

what it is doing that from above output extract data from character position 0, total 4 characters. simple as that. 

see below link for more info.

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

If this post helps you with your problem, please mark your as Accepted solution. If you like my response, please give it a Thumbs Up.

[MicrosoftUser01]

@chandra1 figured it out, thanks again.

substring(body('Current_time'),0,4)

[chandra1]

Cool, @MicrosoftUser01,

could you mark as Accepted solution so other people may have similar issues and can find this useful.

If this post helps you with your problem, please mark your as Accepted solution. If you like my response, please give it a Thumbs Up.

[MicrosoftUser01]

@chandra1 It is still not resolved.

The original question was to take the Form Response Id and in the Create item step for the Microsoft List add another number to it so it adds a set number to the Response Id.

The Response Id is currently 20, I need it to be the input to the List to be Response Id + 250 so the output is:

270/2021

[chandra1 · Accepted solution]

Okay so for that you can use add function.

add(input1, input2)

here input1 will be form response id

input2 will be 250 

as output you will get the total of it.

give it a try. I cloud try to provide code once i am with my computer.

thanks,

[MicrosoftUser01]

The below worked for my specific example. 

add(triggerOutputs()?['body/resourceData/responseId'],250)

I wasn't aware you could include Dynamic content directly into an Expression.