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.
Solved! Go to Solution.
Don't know how to delete this but I solved it myself:
LookUp('[dbo].[APPLICATION]',Text(APP_ID) = ThisItem.APPLICATION_ID,APPLICATION)
Don't know how to delete this but I solved it myself:
LookUp('[dbo].[APPLICATION]',Text(APP_ID) = ThisItem.APPLICATION_ID,APPLICATION)
User | Count |
---|---|
184 | |
123 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
132 | |
85 | |
78 |