How can I convert the optionset to a string that it can be used in the CONCAT function?
I dont know the type picklist, but here are my thougts:
Convert something to text with Text(varToConvert)
I think you can't convert a picklist into a String (but try it anyway!), because it contains multiple records of something. Try to filter your picklist with the following:
Filter(yourPickinglist, fieldToFilterOn="valueToFilterOn")
Good Luck!
Thanks! I tried this already, but without success. It is saying "Function TEXT is not existing".
The picklist is a "Option" and I need the value which is selected.
I think actions in calculated field are limited to the fuctions listed here: Define calculated fields | Microsoft Docs
Has anyone else any idea? Or is it just not possible?
Try this:
Text(yourOptionField.Selected.Value)
This will get the choosen value of your option field.
Let me know if this worked for you (:
Thanks, but this ends in following error: "the formula contains an invalid reference:."
Did you try cr4b7_locationtype.Selected.Value ?
Yes, but same error: "the formula contains an invalid reference:."
With JS I would access the value of the optionset with getText(). But this function is also not known in this context
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
189 | |
53 | |
51 | |
34 | |
33 |
User | Count |
---|---|
268 | |
91 | |
80 | |
68 | |
67 |