Blending Two Conditions in a Dropdown

(0) Share

Report

Posted on by Phineas

5,339 Moderator

Can someone one tell me how to blend the two following conditions into one?

No 1. returns all citis in the region of the city, because the member has a hierarchy of 'Region' (not related to the location region)

If(varProgramHierarchy="National", Sort(Distinct(Filter(Collection, Region = Dropdown1.Selected.Region),City), Result, Ascending))

and

No 2. returns ALL cites, with the list defaulting to the users home city (required)

Sort(Filter(Collection, Title=varCityAlpha), Title, Ascending)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Phineas :

Firstly,let me explain why you encountered this problem.

The key is You cannot assign the item property setting of a control to two sources with different data structures at the same time.The data structures of the return values of your two formulas are inconsistent, which results in you not being able to merge these two formulas directly.

The return value of

If(varProgramHierarchy="National", Sort(Distinct(Filter(Collection, Region = Dropdown1.Selected.Region),City), Result, Ascending))

is a One-Column table something like:

Result

XX

XX

XX

The return value of

Sort(Filter(Collection, Title=varCityAlpha), Title, Ascending)

's data structure is the same as the data source collection

Title City XX XX

XXXX XXX XX XX

XXX XXX XX XX

Secondly,If you only want to get a list of city,please try this formula:

If( varProgramHierarchy="National", Sort( Distinct( Filter(Collection, Region = Dropdown1.Selected.Region), City), Result, Ascending), RenameColumns(ShowColumns(Sort(Filter(Collection, Title=varCityAlpha), Title, Ascending),"City"),"City","Result") )

Best Regards,

Bof
Phineas 5,339 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

All of the first part worked.

None of the second part worked.

Errors:
The function 'RenameColumns' has some invalid arguements
The function 'ShowColumns' has some invalid arguements

Current formula:
If(varIsHierarchyRegion, Sort(Distinct(Filter(ParkListCollection, NPSRegion =Dropdown1.SelectedText.NPSRegion),Park), Result, Ascending). RenameColumns(ShowColumns(Sort(Filter(ParkCollection, Title=varParkAlpha), Title, Ascending), "Park"), "Park", Result))

Why the quotation marks? I'm not looking for a specific Park just ALL, or Any associated with a region.

Thank you,
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Phineas :

If( varIsHierarchyRegion, Sort( Distinct( Filter(ParkListCollection, NPSRegion =Dropdown1.SelectedText.NPSRegion), Park ), Result, Ascending ), RenameColumns( ShowColumns( Sort( Filter(ParkCollection, Title=varParkAlpha), Title, Ascending ), "Park"), "Park", "Result" ) )

Best Regards,

Bof