Unanswered

DropDown not reading collection

(0) Share

Report

Posted on by ctedesco3307

688

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RandyHayes 76,297 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 688 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