Problem with delegating

(0) Share

Report

Posted on by acolyter

Hi,

I've created this Set & LookUp query:

Set(UdalostVar;LookUp(Catering; Name = UdalostDDL.Selected.Result))

But it says that there is a problem with delegation (and warning message saying that it might not work good with big datasamples).

It is working, but is there any other way to do this, so I'm not getting warning message from PowerApps?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Pstork1 69,547 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
I'm not sure if this is the problem or not, but delegation is often a problem when you are using a value that needs to be calculated inside the formula. Such calculations can't be delegated. So try changing your code to the following and see if the delegation warning goes away.

Set(selectedName, UdalostDDL.Selected.Result);; Set(UdalostVar;LookUp(Catering; Name = selectedName))

Was this reply helpful? Yes No
acolyter 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for the reply.

Unfortunatelly, it is still showing me the same message when using the code you advised me to use.

The message:

@Pstork1

Was this reply helpful? Yes No
Pstork1 69,547 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What kind of column is Name? I assumed it was a single line of text. If its a complex column then you need to drill down to the individual text property being evaluated.

Was this reply helpful? Yes No
acolyter 92 on at

Like
a
(0)

Report
Copy link

Link copied!

It is a single line text.

@Pstork1

Was this reply helpful? Yes No
Pstork1 69,547 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I looked back at the error again. Based on the screenshot you haven't removed the reference to the dropdownlist and replaced it with a variable as I mentioned in my former reply. I just tested. If Name is a Single line of text field and you remove the reference to the complex dropdownlist then your code should work without delegation. Please make the changes I recommended and try again.

Was this reply helpful? Yes No
acolyter 92 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried it, but forgot to post the right picture, so here it is:

It's giving me the same warning over and over again.

@Pstork1

Was this reply helpful? Yes No
Pstork1 69,547 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Make sure the Name column in SharePoint is an Indexed column. That's the only other thing that I can think of that would cause this. I tried the code in a large list on a regular single line of text column and I don't have a delegation warning.

Was this reply helpful? Yes No
acolyter 92 on at

Like
a
(0)

Report
Copy link

Link copied!

It works now. I was working with 'title' column that is default by SharePoint and I renamed it to 'Name'. It just didn't work. When I created a new column doing the same as the previous one (Name), it started working. Maybe there's something wrong with using Sharepoint's title column and renaming it.

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

Like
a
(0)

Report
Copy link

Link copied!

@acolyter

Welcome to PowerApps h311. See https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/The-Ten-Commandments-of-SharePoint-in-PowerApps/ba-p/848842#:~:text=%20The%20Ten%20Commandments%20of%20SharePoint%20in%20PowerApps.,16%20Download%2017%20First%2018%20Last%20More%20

Was this reply helpful? Yes No
Verified answer

Pstork1 69,547 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Columns have an internal and a display name. When you change the name of the Title column to name you are only changing the Display Name. You need to use the internal name for a lot of things. That's why it wouldn't work.

Was this reply helpful? Yes No