Skip to main content

Notifications

Power Apps - Error Handling
Suggested answer

Gallery Lookup Text Error

(0) ShareShare
ReportReport
Posted on by 2
Hi!
 
I have been trying to make a Text title in my gallery rectangle, but the item that I want to reference is a lookup column from a PowerApps table. Every formula I use to make the title gives an error, such as "The property on this control expects Text values. The rule produces Record values which are incompatible." All of my other datacards will work with ThisItem.yourdata, except the one, so I think it's having a problem pulling from the lookup column data and the datacard Items = of Choices([@GolfLessons].'crba7_FullName'). I've tried ThisItem.'Full Name'.Value and a variety of Concat functions.
 
If anyone has any ideas, let me know! Thanks!
  • CU21110229-0 Profile Picture
    CU21110229-0 2 on at
    Gallery Lookup Text Error
    Thank you! It's a dataverse table, so comboboxName.Selected.columnName worked to fix the error message, except I was hoping to be able to have the title change based on each form that I make in the app rather than changing all of the titles when one name is selected so that it functions more like a ThisItem. Thanks a lot!
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,388 on at
    Gallery Lookup Text Error
    Are you using SharePoint or Dataverse?
    If using a combobox then it maybe something like comboxName.Selected.Value or comboboxName.Selected.columnName depends on the data source.
  • Suggested answer
    jpespena Profile Picture
    jpespena 330 on at
    Gallery Lookup Text Error
    Hi,
     
    Have you tried:
    ThisItem.'crba7_FullName'.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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard

Featured topics