Unanswered

Question about Delegation Warning using SQL.

(0) Share

Report

Posted on by mstrawn

Hello,

For some context, I have a complex database in Microsoft SQL Server with a junction (or some say link) table because of a many-to-many relationship.

For example, I have a table called UseCases and a table called Drivers. This is a many-to-many relationship, with it looking like this.

My issue is when I want to display the drivers that are aligned to each use case. I have to do a nested filter, because I first need to get all the Driver_id's aligned with the specific UseCase_id from the junction table, and then filter those ID's in the Drivers table to actually show the name values.

My function is this on a dropdown (uc_id is passed into the screen where this takes place. It is the UseCase ID):
Filter(Drivers, key_id in Filter(DriversToUseCase,UseCase_id=uc_id).Driver_id)

However, I am getting a delegation warning on that "in" operator. Is there any advice to get around this? My junction table will likely go over 2000 records at some point, meaning I cannot just ignore the delegation warning. Also, again, I am using SQL server as my data source.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@mstrawn

Would it be possible to create a SQL view to get around the limitation?

Was this reply helpful? Yes No
mstrawn 38 on at

Like
a
(0)

Report
Copy link

Link copied!

I can try that.
Would it not still be the same issue as I will be basically saying:
Filter(Drivers, key_id in viewname)

Or would it work differently?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@mstrawn

I don't know much about Sql but can you produce a view that includes the filter?

Was this reply helpful? Yes No
mstrawn 38 on at

Like
a
(0)

Report
Copy link

Link copied!

I did get a procedure to work, and it returns the values and I stored them as a collection using:
ClearCollect(varDrivers,ViewDriversToUseCaseDrivers.Run(uc_id).ResultSets.Table1);

When I hover over the collection, I see:

So it is getting the data right. However, I want those 3 rows to be the defaultselecteditems on my combobox. The combobox does have those entries as part of its data source. How can I populate the defaultselecteditems with whatever is stored in that collection?

Was this reply helpful? Yes No