Answered

Possible limitations with using additional SP list in a choice datacard? Not all items are shown in the dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Observed an issue where some values in the Sharepoint list do not appear in the dropdown where that Sharepoint list is used as a datasource.

The formula I have for the Choice datacard is

SortByColumns(Eng_list_Bal1.'Eng Number', "Eng_x0020_Number",Descending)

One of the observed values that are missing is 36264687

Screen 1 shows that this value appears in the Sharepoint list that I am using as a datasource;
Screen 2 shows that this vaue is omitted in the dropdown list (based on the descending order, it should be above the 36246537 value)

Perhaps someone knows if there is a solution to somehow reveal missing values? I have tried refreshing the datasource and reimport the Sharepoint list but these methods didn't help. Would sincerely appreciate any advice.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

sayyed007amir 357 on at

Like
a
(1)

Report
Copy link

Link copied!

I think if you create a dummy record with same column value: 36264687, then check it appears on dropdown or not.
May be your value contains space.
Thanks
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @sayyed007amir ,

Thanks! How could I add a dummy variable? I've checked the original source and the values did not contain spaces..

I another post related to my message, which reported that dropdowns have a limit of 500 or so items: https://powerusers.microsoft.com/t5/Building-Power-Apps/Drop-down-List-Items-Limites-to-500/td-p/98812

The accepted solution suggested creating a collection and then used it instead of Sharepoint list.. However, even have added a combobox and changed the Items source, I cannot find value: 36264687..
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This link provided solutions to avoid the limit of 500 items: https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/
sayyed007amir 357 on at

Like
a
(0)

Report
Copy link

Link copied!

But as i looked over your scroll bar on screenshot, it was not like more than 500 records.
So don't worry about that.
Dummy means: create new record with same data(data: which is not showing in your dropdown).
Then see will work definitely.