Ref number with variables

[Lefty]

Hi all,

I am stuck with the following if someone could help:

I have a canvas app using SP list as its data source.

I have previously auto populated my ref number using the default ID field of a SP list, but now I need to increment the number from a choice column found in the form.

In a choice column the user has the following values:

TeamA

TeamB

TeamC

TeamD

When a user select TeamA I want the ref number to be 0001 and increment each time any user then submits a record, 
and when the user selects TeamB I want the ref number to also be 0001 and increment and so on for the remainder

Many months ago I learnt (Thanks PA community) the best way to increment ref numbers was using the SP ID  field and in other methods I found there was a chance of 1 record having the same ref number, maybe when 2 users were submitting at similar times.

If any one has any suggestions please let me know

Thanks

[timl · Accepted solution]

Hi @Lefty 

Apologies for the delay in answering. I assume you HTML box is on an edit form?

If this is the case, a solution would be to set the item property of the form to the variable (eg vFormItem). In edit mode, you would set this variable to the record that you want to display on the form.

In the case where you add a new record, following the call to Patch, you would set vFormItem variable to vPatchedRecord and call Reset on your HTML box. This should configure the HTML box to show the updated record with the new serial number.

[Lefty]

Hi @timl 

Afraid I do not have my HTML box on a edit form - it wasnt directly linked to anything - I just needed it to gather the values so I can get Power Automate to use it for creating the PDF.

Would you suggestion need to be tweaked to get this to work for me?

[timl]

Hi @Lefty 

If your HTML box isn't on an edit form, you can still use the same technique.  That is, after the call to Patch, you would gather the values from vPatchedRecords. If you post the formula you use to set the HTML text for the HTML control, I can advise further.

[Lefty]

Hi @timl 

Thanks You have actually guided me to what I need to do, just wasn't thinking straight.

I can add the HTML control on the same screen, hide it and reference the reference number via the patched record. I need to test this but in theory I can't see why not

Thanks for your help on this