Dears,
I have created a gallery of tasks for different teams with a filter based on owner for task not yet completed
Final formula (that works) is
Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata"))
Now, the same board is used by different team and I would like to add an additional condition with the filter that will also check the content of the dropbox field "Team"
The dataset is in sharepoint
I tried the folowing:
Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata") & Filter('PR&C Accountability Board', TextInput2.Text in Team)
but does not works. Can you help me?
Solved! Go to Solution.
Navigating and trying.... success again.
I have created a Dropdown box with the formula
["Tier 1 Complaint","Tier 1 Release","Tier 2"]
Than into my gallery I have changed my formula as following
Filter('PR&C Accountability Board', (Dropdown1.Selected.Value in Team.Value) && TextInput1.Text in Owner &&Not(Status.Value="Completata"))
and... WORKS PERFECTLY!
I'm really proud
Try
Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata")&&
TextInput1.Text in Owner)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
The And && Formula will return values where all conditions are met. Have you entered anything in the 2 textboxes. You can also replace && with Or.
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
I tried the following:
Filter('PR&C Accountability Board'; TextInput1.Text in Owner &&Not(Status.Value="Completata") or TextInput2.Text in Team)
and
Filter('PR&C Accountability Board'; TextInput1.Text in Owner &&Not(Status.Value="Completata")) && Filter('PR&C Accountability Board'; TextInput2.Text in Team(Status.Value=""))
does not works.
Navigating and trying.... success again.
I have created a Dropdown box with the formula
["Tier 1 Complaint","Tier 1 Release","Tier 2"]
Than into my gallery I have changed my formula as following
Filter('PR&C Accountability Board', (Dropdown1.Selected.Value in Team.Value) && TextInput1.Text in Owner &&Not(Status.Value="Completata"))
and... WORKS PERFECTLY!
I'm really proud
User | Count |
---|---|
197 | |
125 | |
88 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
73 |