I have Gallery1.
It is pulling in data from a SharePoint Library.
Several of the library columns are choice colums, including 'Assigned to'.
All except the 'Assigned to' are returning the proper data.
I am using the following formula in 'Assigned to'.
It is returning the error -
"Expected Text value"
What am I missing?
its a choice column correct
try this :
Sort(
Choices('01-Client Flies_1'.Assignedto),Value,SortOrder.Ascending)
Check ComboBox > Fileds
Okay, I got my gallery field to populate with -
ThisItem.'Assigned to'.Value
This is based on my Combo Box having -
'01-Client Flies_1'.Assignedto
However the above is not showing in content in the Combo Box list.
I want my Combo Box to display the client names in ascending order.
What am I missing.
Try this
before value "," not .
Concat(Thisitem.'Assigned to',Value, ",")
not this one : Concat(ThisItem.'Assigned to'.Value, ",")
are you show that Assigned to value into Textinput or Dropdpown
Text input to use :- Concat(ThisItem.'Assigned to',Value, ",")
Dropdown to use :- ThisItem.'Assigned to'
New error - Invalid use of a ' . '
Formula -
Concat(ThisItem.'Assigned to'.Value, ",")
HI @Phineas
Its multiple-choice column correct or its have single value
Try this : just modify that code
Concat(Thisitem.'Assigned to',Value, ",")
Only the ' , ' (comma) comes through.
MS.Ragavendar
10
LC-26081402-0
6
EE-04041031-0
4