Skip to main content

Notifications

Community site session details

Community site session details

Session Id : xbjKUUUzvA/ovIvaqx2eOm
Power Apps - Building Power Apps
Answered

This Item Formula Returning 'Expected Text Value' Error

Like (0) ShareShare
ReportReport
Posted on 29 Mar 2024 05:01:51 by 4,758 Super User 2025 Season 1

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:
  • Verified answer
    Yogesh Murugan Profile Picture
    443 Super User 2025 Season 1 on 29 Mar 2024 at 06:30:30
    Re: This Item Formula Returning 'Expected Text Value' Error

    its a choice column correct

    try this : 

     

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

     

    Check ComboBox > Fileds

    YogeshMurugn_0-1711693821334.png

     

  • Phineas Profile Picture
    4,758 Super User 2025 Season 1 on 29 Mar 2024 at 06:21:28
    Re: This Item Formula Returning 'Expected Text Value' Error

    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

     

     

  • Yogesh Murugan Profile Picture
    443 Super User 2025 Season 1 on 29 Mar 2024 at 05:51:14
    Re: This Item Formula Returning 'Expected Text Value' Error

    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
    4,758 Super User 2025 Season 1 on 29 Mar 2024 at 05:49:01
    Re: This Item Formula Returning 'Expected Text Value' Error

    New error - Invalid use of a ' . '

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

    Phineas_0-1711691277115.png

     

     

  • Yogesh Murugan Profile Picture
    443 Super User 2025 Season 1 on 29 Mar 2024 at 05:40:08
    Re: This Item Formula Returning 'Expected Text Value' Error

    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
    4,758 Super User 2025 Season 1 on 29 Mar 2024 at 05:26:46
    Re: This Item Formula Returning 'Expected Text Value' Error

    Only the ' , ' (comma) comes through.

    Phineas_0-1711689974122.png

     

  • Yogesh Murugan Profile Picture
    443 Super User 2025 Season 1 on 29 Mar 2024 at 05:21:26
    Re: This Item Formula Returning 'Expected Text Value' Error

    Hi @Phineas 

    Maybe its multiple choice column 

    Try this : 

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

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 10

#2
LC-26081402-0 Profile Picture

LC-26081402-0 6

#3
EE-04041031-0 Profile Picture

EE-04041031-0 4

Overall leaderboard