web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / This Item Formula Retu...
Power Apps
Answered

This Item Formula Returning 'Expected Text Value' Error

(0) ShareShare
ReportReport
Posted on by 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?

Phineas_0-1711688154183.png

 

Categories:
I have the same question (0)
  • Yogesh Murugan Profile Picture
    447 Moderator on at

    Hi @Phineas 

    Maybe its multiple choice column 

    Try this : 

    Concat(Thisitem.'Assigned to'.Value, ",")
  • Phineas Profile Picture
    5,331 Moderator on at

    Only the ' , ' (comma) comes through.

    Phineas_0-1711689974122.png

     

  • Yogesh Murugan Profile Picture
    447 Moderator on at

    HI @Phineas 

    Its multiple-choice column correct or its have single value 

    Try this : just modify that code

    Concat(Thisitem.'Assigned to',Value, ",")

     

  • Phineas Profile Picture
    5,331 Moderator on at

    New error - Invalid use of a ' . '

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

    Phineas_0-1711691277115.png

     

     

  • Yogesh Murugan Profile Picture
    447 Moderator on at

    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'

  • Phineas Profile Picture
    5,331 Moderator on at

    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.

    Phineas_0-1711693162884.png

     

     

  • Verified answer
    Yogesh Murugan Profile Picture
    447 Moderator on at

    its a choice column correct

    try this : 

     

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

     

    Check ComboBox > Fileds

    YogeshMurugn_0-1711693821334.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard