web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Group By, expected tex...

Power Apps

Unanswered

Group By, expected text value error

(0) Share

Report

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I use this statement fine -

GroupBy('Scheduling List',"field_2","Title")

then when I want to use ThisItem.Title in a label I get error "Expected Text Value".

However I can use ThisItem.field_2 just fine.

Any reason why?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
Use the First function to get the first record from the Title column, and then use the Value property to get the text value from that record:
GroupBy( 'Scheduling List', "field_2", First(ThisItem.Title).Value )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@SpongYe

getting error still -

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
@wonka1234

If you add a label to your gallery control and set the Text property to the following, that should hopefully work.

First(ThisItem.Title).Title

Was this reply helpful? Yes No

Join the conversation