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.
