I have a table like this:
|Col 1||Col 2|
I have already connected the table in powerapps but in the gallery i want to show names from col 1 but only for "Operational" value in Col 2
I am trying to use this but it is not working:
Filter(Table 1,'Col 2',"Operational")
And then for the label in gallery : This item.Col1
Appreciate your help.
Please consider changing your Formula to the following:
Filter(Table 1, 'Col 2'="Operational")
I hope this is helpful for you.
Hi @Aditya1728 ,
Are you using a CDS table as DataSource?
Is your "Col 2" a Choice column?
If yes, you can try this formula:
Filter('Table 1','Col 2'=[@'Col 2'].Operational)
Pay attention to the Choice name inside the Choice column(they may be different):
Please clarify your datasource if you are still experiencing the issue.
@v-albai-msft No it is not a choice column, a normal table formatted in excel
@RandyHayes Yes still the same problem.
I get the following error:
The requested operation is invalid. Server Response: <Table Name>: Syntax error at position 26 in '<column name> eq '<value sued to filter>'.inner exception Syntax error at position 26 in '<column name> eq '<value sued to filter>'
Can you provide your current formulas for:
- The Gallery Items property.
- The Text properties of the two labels
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.