Distinct Function not bringing correct result in dropdown data based on Sharepoint list

[MIA27]

I am using the below formula in the Items property of the dropdown 

Distinct(KomtraxImport,F3)

It has no error but the result is not correct.

The sharepoint list has 2356 records and should bring result of more than 12 rows

But it just bring the 1 row result only.

please guide

[MIA27]

Sir,

I copied the code as mentioned and paste, it has another error, below is the screen shot

Please guide, how to correct it.

Regards

[BCBuizer]

HI @MIA27 ,

From the screenshot it seems you have applied this to the dropdown, whereas it should be set for the OnVisible property of the screen. 

[MIA27]

Sir,

sorry, In hurry I applied at wrong properties. Now I corrected. Applied the code on visible and distinct code on the dropdown.

Now, no error no records in the dropdown. Pls. guide

[BCBuizer · Accepted solution]

Hi @MIA27 ,

Did you trigger the OnVisible property before testing? An easy way to do that is to go to preview mode by pressing the play icon at the top right of the screen or to press F5.

[MIA27]

Sir,

I did the testing by Play before but it was not working.  Later after your last advise tried another by  I focused to another screen and then came back and play, found its working. But it showing only few records, it should bring 32 rows records , below is the screen shot during play. Also tried to move manually in dropdown by arrow but only these records in the row is showing. could not understand its working where is the balance row.

Pls guide

[BCBuizer · Accepted solution]

Hi @MIA27 ,

Can you please insert a temporary label with the below as the formula for the Text property:

CountRows(colMyCollection)

The displayed number should match the number of items in your data source ('KomtraxImport') to verify if the collection has all the items.

[MIA27]

Sir,

As advised, I added a label and added the formula as you guided.

Found Result of collection is not same as of the total records of list.

Collection shows only 1000 while the total records should be 2356

below is the screen shot during play 

Image of records at sharepoint list

Please guide .

Regards

[BCBuizer · Accepted solution]

Hi @MIA27 ,

What is your current Data Row Limit?

You can find this by going to Settings, Settings and then scrolling down:

If it is 500, please change it to 2000 and then try again.

[MIA27]

Sir,

Thank you so much, its done. Got the correct result after changing the limit.

Not only solved, but also learnt so many thing during your guidance process.

Thanking you again for your help and given time.

very best regards.

[MIA27]

sir,

Just wanted to confirm as these dropdown is used to filter the gallery.

By default it goes to the first records, 

Is it possible to keep the first row Blank, so that at the opening time all the records will come up,

If user wants he can select as required.

Can I add like below :

IsBlank();Distinct(colMyCollection, F3).Value

To get the first row blank and then the data row