Answered

Dropdown options from datatable in excel online

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am having trouble populating a dropdown by filtering options from a datatable. The items are from a certain column, filtered by a different column value.

Here is my code in the Items value of the dropdown - Sort(Distinct(Filter(Table5,'Issue Type'="Project"),Summary),Result) - This should show options from the 'Summary' column in Table5 where 'Issue Type' equals "Project"

This was working recently but has now broken.

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,333 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @luredrive ,

Really the same thing, but avoiding the Delegation warning, but try this

With( { wItems: Filter( Table5, 'Issue Type' = "Project" ) }, Sort( Distinct( wItems, Summary ), Result ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , unfortunately that hasn't worked.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The datasource is an excel online document table, if that changes anything? I know excel isn't a good database but it's the only solution I need right now, using a sharePoint site isn't an option.

Was this reply helpful? Yes No
WarrenBelz 156,333 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @luredrive ,

Yes, that makes a bit of sense now. I do not (for may good reasons) use Excel and complex filters are often not "good friends" with it due to its (very) limited Delegation capability. I am surprised however that what I posted does not as the only interaction with the data source is in the top With() statement. How many records are involved here ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I know, it is a bit of a bodge job because the information is actually taken from Jira via a download.

There are ~170 records that the filter needs to work with. The records I am interested in are from rows 1-any number so I can't even capture a group of records as it's dynamic.

Was this reply helpful? Yes No
WarrenBelz 156,333 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@luredrive ,

Maybe something corrupt in the connection. Try reconnecting, but other than that, it should work.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Found a solution -

Sort(Distinct(Filter(Table5,"Project" exactin 'Issue Type'),Summary),Result)

Not sure why the previous options did not work but this does.

Was this reply helpful? Yes No