web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown to show "All"...

Power Apps

Unanswered

Dropdown to show "All" and the sharepoint records

(0) Share

Report

Report

Posted on by AustineHype

16

Hello

I have a sharepoint table with a column called"Name" and basically I want to create a dropdown field that shows all the existing records under the "Name" column but still has a choice to select "Show All". The "Show All" value does not exist in my sharepoint table.

Here is my measure for the dropdown -> Items -> ForAll(Distinct(Tasks,Name), {Result: ThisRecord.Value})

It shows all the existing records that are good but the only thing I am missing is the "Show all" that I can select.

Thanks for help

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AustineHype , Please check this video https://www.youtube.com/watch?v=nlfZD6lsCDc which can help you to add "Show All" or "All" item in dropdown with other names.
OR check this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-add-All-option-in-dropdown/td-p/1996028
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ 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 Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
One way to add the "all items" is to set up a collection that contains both the "all items" entry and all the other items, and then use that collection for the items property of the dropdown. For example, you could put the following in the app start event:

ClearCollect(colMyChoices,{Value:"All Items"}); Collect(colMyChoices, ForAll(Distinct(List,Title), {Value: ThisRecord.Value}))

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation