cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MamathaReddy694
Helper II
Helper II

powerapps - Filter

 Hi,

 

  • I am unable to Filter the columns , Filter formula is not working for my form I have 3 Fields Baside on 1 field the next fields should display , Suppose I have 1 Droupdown(ZONE=AOA) if selected this fields the next fields(MARKET) I should get which values are belongs to AOA MARKETS should come,
  • I am using this formula :-  Distinct(filter(Table_name ,columnName=Droupdown.slectedText.value),ColumnName) .
  • my Data is coming from DataBase .

 

 

Can any one help on this issue 

1 ACCEPTED SOLUTION

Accepted Solutions
MamathaReddy694
Helper II
Helper II

Hi ,

  • I am unable to Filter the columns , Filter formula is not working for my form I have 3 Fields Baside on 1 field the next fields should display
  • Suppose I have 1 Dropdown(ZONE=AOA) if selected this fields the next fields(MARKET) I should get which values are belongs to AOA MARKETS should come,
  • I am using this formula :-  Distinct(filter(Table_name ,columnName=Droupdown.slectedText.value),ColumnName) .
  • my Data is coming from Database .
  • cascading drop-down .

View solution in original post

7 REPLIES 7
eka24
Super User III
Super User III

On your dropdown, use can this on the items property:
Distinct(TableName,ColumnName)
Also for the filter use:
Filter(TableName,Dropdown1.Selected.Value)

Please change the TableName, ColumnName and dropdown name to your actual names.

You can give a screenshot that will help solve it.


If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution
MamathaReddy694
Helper II
Helper II

Hi ,

  • I am unable to Filter the columns , Filter formula is not working for my form I have 3 Fields Baside on 1 field the next fields should display
  • Suppose I have 1 Dropdown(ZONE=AOA) if selected this fields the next fields(MARKET) I should get which values are belongs to AOA MARKETS should come,
  • I am using this formula :-  Distinct(filter(Table_name ,columnName=Droupdown.slectedText.value),ColumnName) .
  • my Data is coming from Database .
  • cascading drop-down .

View solution in original post

The screenshot is fine. Please use this formula:
Filter(MapCap,country=DataCardValue12.Selected.Value)
Let me ask, are they multiple same names I'm the table, that's why you are using Distinct?
If it doesn't work, take a screenshot of the first dropdown items.

Hi ,

 

  • I Want Cascading drop-down

      I have attached an file where I am getting error

  1.  I am selecting (zone) as AOA , AOA markets should display in my cascading drop-down

Hi ,

 

I have tried you are formula , it's not working ,

For my first dropdown I am using Distinct , Distinct is working fine for first Dropdown ,

For second dropdown I want filter, distinct,

 

you can see the screenshot which I have attached now  , I have used your formula.

 

Are you using Two different tables for the dropdowns or the same table for each dropdown. If they are Different, do you have country in both tables

I asked for the Screenshot of the first because i want to see the Table for the one working.

The error shows country may not be in the filter for first dropdown

 

Hi,

 

  I am using Two different tables for the dropdowns, yes there are different as in one table the column name is Market(This table is Where I need to submit the form) and In the other table name is Country ( this table is where I am getting the data), only the column name and table names are different but data is same ,

 

I have attached the screenshot.

 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (74,807)