Unanswered

PowerApps Distinct formula - All data not being returned

(1) Share

Report

Posted on by CU06052007-0

Hello,

I am customizing a SharePoint Form in SharePoint online using PowerApps. I am retrieving data into to a combo box using the following formula:

Distinct(CityToBranch_Lookup, Province)
 
Although the list I am retrieving data from contains less than 3500 records, all the provinces in the list are not being returned. I would like to know how I can have all available values returned. I am only receiving 4 of the 5 options back to my combo box.
 
thanks,
Sherazad

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU06052007-0

Is that an actual lookup or you just named it with lookup?

Also, are you seeing any delegation warnings?

I'd really like to see the data (at least some) as well as a little more detail around the relationship between the data.

How many unique Provinces are you expecting?

Forget about sharepoint/forms bla bla, just create a Canvas App, add the List and do the same thing, see what you get.

Was this reply helpful? Yes No
CU06052007-0 6 on at

Like (0)

Report

Hi Michael,

No, it's not an actual lookup. Just the name of the file.

There are no warnings or errors. And I am expecting 5 unique provinces. Please see a sample of the data attached.

I will try your suggestions with the canvas app.

thanks,

Sherazad.

CityToBranchesDat...

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @CU06052007-0,

I will throw in here the fact that Distinct is not supported with Delegation from SharePoint, though unfortunately for some reason the warning has disappeared. If this helps, I have a blog on a possible workaround that may be useful.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
CU06052007-0 6 on at

Like (0)

Report

Hi Warren,

That's exactly what I found out yesterday. Thank you for the workaround which I will consider in future. I did workaround of my own which involved creating a small list with the 5 provinces which resolved my issue.

thanks,

Sherazad.

Was this reply helpful? Yes No