Answered

This Item Formula Returning 'Expected Text Value' Error

(0) Share

Report

Posted on by Phineas

5,331 Moderator

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Yogesh Murugan 447 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Phineas
Maybe its multiple choice column
Try this :
Concat(Thisitem.'Assigned to'.Value, ",")

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Only the ' , ' (comma) comes through.

Was this reply helpful? Yes No
Yogesh Murugan 447 Moderator on at

Like (0)

Report
Copy link

Link copied!
HI @Phineas
Its multiple-choice column correct or its have single value
Try this : just modify that code
Concat(Thisitem.'Assigned to',Value, ",")

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

New error - Invalid use of a ' . '

Formula -
Concat(ThisItem.'Assigned to'.Value, ",")

Was this reply helpful? Yes No
Yogesh Murugan 447 Moderator on at

Like (0)

Report
Copy link

Link copied!
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'

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Yogesh Murugan 447 Moderator on at

Like (0)

Report
Copy link

Link copied!
its a choice column correct
try this :

Sort( Choices('01-Client Flies_1'.Assignedto),Value,SortOrder.Ascending)

Check ComboBox > Fileds

Was this reply helpful? Yes No