Answered

Lookup not returning all records

(0) Share

Report

Posted on by Fess67

Hi,

I have a Combobox (SkillPicker_1) taking values from a SP list. This works as expected and users can pick the desired skill.

Sort(
Distinct(
MatrixSkills,
SkillName
),
Ascending
)

I then perform a lookup of the result to return the category of the skill which I output to a label.

LookUp(
 MatrixSkills,
 SkillPicker_1.Selected.Result = SkillName,
 SkillCategory
)

This works some of the time and other times will not return the category. I get no delegation warnings. My list is only 300 items long so delegation should not be an issue.

The records that are not being returned correctly are within the body of the list. i.e. there are records later in the list which are returned correctly.

Thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@Fess67

A couple of things you could check / do:

1. Use a Dropdown instead of a ComboBox. Comboboxes have their own special way of operating in PowerApps sometimes. I tend to think they have a mind of their own, lol

2. Double check that your Data row limit is set to >300 (2000 is better) under File --> Settings --> Adv Settings

3. Lookup returns the first record it finds. Is it possible that when it's not working that the SkillCategory related to that SkillName for the returned record is BLANK? ie do ALL records have a SkillCategory or are there some blanks?

Was this reply helpful? Yes No
Verified answer

Fess67 85 on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks @Eelman ,

Changed to a drop down and the same behaviour is present
Yep, limit set at 2000. Records do not exceed 2000 and no delegation warnings
No blanks in the dataset.
But, the 'no blanks' got me to thinking and I have the SP list as a single line of text so I went looking and due to how the user is copy and pasting it may be that an anomaly is being introduced. I found a couple with <br> which effectively makes them multiple lines. So I removed the <br> and now the expected result is returned.

Problem is if I change the SP list to multiple lines of text I get a delegation warning in my Lookup so it looks like @Fess67 just lost his afternoon to manually removing breaks from a SP list 🙂

Thanks for taking the time to respond and helping me think this through.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Fess67

Bloody data hey!! Who'd use it haha

Well done on spotting that small anomaly in your text data, that's a great pick-up. Mark your answer as the solution here because this will definitely help out any future PowerAppsters with a similar issue.

Good luck with your afternoon, I hope you get to enjoy some of it 🙂

Cheers

Was this reply helpful? Yes No