Issues with using SQL Tables and LOOKUP in PowerApps Gallery

(0) Share

Report

Posted on by Oliclusive

Hi Community,

this is my first time trying to combine SQL Tables in PowerApps and I came across a strange "phenomena":

The idea is that the App would list Data from the "DowntimeSlaveData Table" while performing a LOOKUP of the "SlaveID" in the second Table ("WermaMaschinen") and then display the "WermaDescription" in the Gallery.

When testing the App I realized that it only works for SlaveID's < 11, for all Slave IDs >= 11 it gives me "no data to display"

Please review the attached Screenshots:

1 - PowerApp Gallery SlaveID greater 11: shows the issue ("keine Daten" = "no data")
2 - DowntimeSlaveData Table: shows the structure of the Table incl. the Slave ID's (where you see that SlaveIDs > "11" exist, e.g. "24" as an example)
3 - WermaMachineIDs: shows the additional information needed for the Lookup ("Decription") and you will see that also here SlaveID's > 11 exist. E.g. the Slave_ID "24" should give the result "147 Deco 20"
4 - Power App Gallery Slave ID smaller 11: shows that the exact same filtering code receives correct results for SlaveIDs < 11

As I said its my first kind of App interfacing directly with multiple SQL table so the issue might be on my side. I appreciate any help to find the bug

Thank you very much

Cheers,

Oli

Categories:

Building Power Apps

3 - WermaMachineI...

2 - DowntimeSlave...

1 - PowerApp Gall...

I have the same question (0)

All responses (5)

Answers (3)

Oliclusive 65 on at

Like (0)

Report

the last Screenshot

4 - Power App Gal...

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Hi @Oliclusive ,

How many records are there in DowntimeSlaveData Table?

It looks like a delegation issue, since the Addcolumns function is not delegable, so it can only retrieve back 500 records (you can increase the threshold to 2000).

If you only want to show the related Werma_Description in DowntimeSlaveData Gallery, there is no need to use AddColumns function to save it to the backend source, just show it in the Label inside the gallery, please try this:

Set the Gallery.Items property:

Filter('[dbo].[Werma_DowntimeSlaveData]'; slaveId>11)

Add a Label in the gallery, set Text property:

LookUp('[dbo].[Werma_Maschinen]'; Slave_ID= ThisItem.slaveId).Werma_Description

Hope this helps.

Sik

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Oliclusive

The other thing I would check is whether or not the data type of slaveId is definitely numeric in your SQL table.

If the data type of slaveId is text, that would explain why the > operator doesn't return expected results

Was this reply helpful? Yes No
Oliclusive 65 on at

Like (0)

Report

Hi - yes I checked it's numeric

Was this reply helpful? Yes No
Verified answer

Oliclusive 65 on at

Like (0)

Report

Hi @v-siky-msft , your gut feeling was right, in relation to the delegation issue! As I need the Addcolumn statement now I filtered the raw data first in an SQL view and by that reduced the lines imported drastically before carrying out the Addcolumns statement. Now everything works fine. THis is awesome - thank you :))

Was this reply helpful? Yes No