web

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

Power Platform CommunityForums Power Apps - Building Power Apps DropDown not reading c...

Power Apps - Building Power Apps

Unanswered

DropDown not reading collection

(0) Share

Report

Report

Posted on by ctedesco3307

659

Hi All - seen some similar posts but none fixes this issue. I have a drop down - simple read from a sharepoint column - works great -

But then I try to put that DISTINCT statement in a collection, (ultimately so I can add and "ALL") and the dropdown won't read the collection. what am I missing? thanks in advance

Categories:

Connecting to Data

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

RandyHayes 76,291 Super User 2024 Season 1 on at

Like (0)

Report
Re: DropDown not reading collection

@ctedesco3307

Don't waste your time with duplicating data in collections...just set your Items property of your dropdown to:

Ungroup( Table({Items: Table({Result: "All"})}, {Items: Sort(Distinct('PS Contract Totals', 'Project Key'), Result)} ), "Items" )

I hope this is helpful for you.

Was this reply helpful? Yes No
ctedesco3307 659 on at

Like (0)

Report

Re: DropDown not reading collection

@RandyHayes - thanks for the answers. I did know that if I put what I needed into the items property it worked. I appreciate the "All" syntax added. Isn't creating a table the same concept as duplicate info in a collection? It works, but I really wanted an answer to the problem of why the collection wasn't read by the dropdown. Even though there may be a work around for this instance, there may be another instance where collections are the way to go, and I'd just like to know how to make that work. Thanks again!

Was this reply helpful? Yes No

Join the conversation