Answered

Generate ID filed + text based on another field (radio choices)

(1) Share

Report

Posted on by micha_a

I would like to generate an ID field that displays the initials of the previously selected platform from a radio menu, along with an incremented number.

The formula I have on my ID field is:

Switch(ThisItem.'Publication platform'.Value, "City Intelligence", "CI", "Data Seeing Room", "DSR", "Intelligence Hub", "IH", "Open Data", "OD") & Text(CountA(Filter('Publication Metadata'.'Publication platform','Publication platform'.Value='Publication platform'.Value))+1)

So ideally what I want is for example if City Intelligence was selected from the radio choice, the ID will be : CI1, then the next logged item CI2 etc.

Am I using the wrong formula? It's worth mentioning that once they click on adding a new item, a pop up window will show up, they will have to select the platform and then it will take them to the Edit Form where the Publication Platform is already prepopulated with the field that was already selected from the pop up. - pics below

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @micha_a,

The code looks good but looks like ThisItem.'Publication platform'.value is returning blank, which is why ID shows a number only.

Can the publication platform radio button selection be obtained another way, for example with code similar to the following:

rdoPublicationPlatform.Selected.Value

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
micha_a 43 on at

Like (1)

Report
Copy link

Link copied!

Changed it to Radio1.Selected.Value and it works perfectly, thank you

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

My pleasure! Well done for getting it working, and thank you for the update.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No