cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShowMeTheAnswer
Level: Powered On

Lookup not working on Default: Property Expects Text Values but this propery expects record

Part of a wider problem, but if someone can just help me with this tiny bit.

I want that this formula works as a default for a drop-down in a dataform:

LookUp('[dbo].[APPLICATION]',APP_ID = ThisItem.APPLICATION_ID.value)

 

e.g. ThisItem has an APP_ID.

The APP_ID is stored in the MAIN table, and we need to lookup what application it's for in the APPLICATION table.

The absolute simplest thing to do in SQL, like this:

SELECT [MAIN_ID],[APPLICATION_ID],app.APPLICATION

fROM [MobileDataStudio].[dbo].[MAIN]

inner join [dbo].[APPLICATION] app on APPLICATION_ID=APP_ID

 

But PowerApps just says (meaninglessly, and incorrectly) "This Property Expects Text Values but this propery returns incomptiable record values".

I tried putting "Value" after it; it makes no difference, and surrounding the whole thing with text.

Looked it up online but nothing there worked. Seems like "PowerApps" can't even handle a basic select query, or frankly, anything where joined tables are involved. It only works if you have one big table with everything in.

 

1 ACCEPTED SOLUTION

Accepted Solutions
ShowMeTheAnswer
Level: Powered On

Re: Lookup not working on Default: Property Expects Text Values but this propery expects record

Don't know how to delete this but I solved it myself:

LookUp('[dbo].[APPLICATION]',Text(APP_ID) = ThisItem.APPLICATION_ID,APPLICATION)

View solution in original post

1 REPLY 1
ShowMeTheAnswer
Level: Powered On

Re: Lookup not working on Default: Property Expects Text Values but this propery expects record

Don't know how to delete this but I solved it myself:

LookUp('[dbo].[APPLICATION]',Text(APP_ID) = ThisItem.APPLICATION_ID,APPLICATION)

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 380 members 6,009 guests
Please welcome our newest community members: