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)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report
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 (0)

Report

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 68,717 Most Valuable Professional on at

Like (0)

Report

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 (0)

Report

It is a single line text.

@Pstork1

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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 (0)

Report

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 68,717 Most Valuable Professional on at

Like (0)

Report

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 (0)

Report

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 (0)

Report

@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 68,717 Most Valuable Professional on at

Like (1)

Report

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