Answered

Powerapp drop down list not displaying latest item

(1) Share

Report

Posted on by DT-14120550-0

Hi All,

I have a powerapp that has been working fine. The app received it data source from sharepoint list. The list will be updated on the end of each month on the item (month) for the following month. Now the app dropdown list is not displaying beyond the 7 entrees which is the month May 2025, even the list is already has it. I am using the app as an checklist purpose. Is there something i need to do to show May 2025 or increase the entrees view?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

hey

maybe you need to make sure to refresh the datasource

you can put ot on app-onstart or onvisible of first screen simply use Refresh(NameofDataSource) you just need to insert the name of your SP list.

If my answer was helpful and it solved your issue please mark it as verified answer. If it helped but did not solve please consider giving me a like :)

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

Like (2)

Report

Hi @DT-14120550-0,

Please post the Items of the Combo Box and the type of field it is referencing. Also how many records are in the List ?

Was this reply helpful? Yes No
DT-14120550-0 41 on at

Like (1)

Report

Hi @WarrenBelz

It has 638 records.

Here the screenshot of what you requested:

Thank you

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (2)

Report
Hi @DT-14120550-0,

The issue is that Distinct is not supported with Delegation. Increase your Data Row Limit to more than the number of records in your list (max 2,000). The other thing you can do to get only the newest items
Distinct( Sort( 'Exit/Emergency List List 2', ID, SortOrder.Descending ), Title )

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
DT-14120550-0 41 on at

Like (1)

Report

hi @WarrenBelz

Thanks for the formula! It works and I will change the list row limit.

Was this reply helpful? Yes No