My current formula for my Gallery Items property is:
If(isAdmin,Sort(AllTickets,Created,Descending),Sort(Filter(AllTickets,Author.Email=MyProfile.Mail||Author.Claims=MyProfile.UserPrincipalName),Created,Descending))
I would like to add search functionality to filter all tickets:
Search(AllTickets, SearchBox.Text, "Title", "AssignedTo","Priority","TaskStatus")
However I am not sure where to put this at to allow both displaying all tickets and letting me search the gallery.
Any suggestions?
Solved! Go to Solution.
Hi @PowerAddict ,
So far it is not possible to use the Search function for column types other than strings.
There is a workaround which is using a collection created with your SharePoint list, then use the AddColumns function to run a calculation on the non-text field and turning it into a new field that was a text item. Then use Search on the newly created field.
AddColumns(myTable, "newColumn", PlainText(oldColumn.Value))
Regards,
Mona
it is saying the Search function has some invalid arguments.
Apologies it does work. When it is the following:
If(isAdmin,Sort(Search(AllTickets, SearchBox.Text, "Title"),Created,Descending),Sort(Filter(Search(AllTickets, SearchBox.Text, "Title"),Author.Email=MyProfile.Mail||Author.Claims=MyProfile.UserPrincipalName),Created,Descending))
However whenever I add anything other than "Title" it states that there are some invalid arguments.
No other way around this to search choice fields or drop-downs or anything?
Hi @PowerAddict ,
So far it is not possible to use the Search function for column types other than strings.
There is a workaround which is using a collection created with your SharePoint list, then use the AddColumns function to run a calculation on the non-text field and turning it into a new field that was a text item. Then use Search on the newly created field.
AddColumns(myTable, "newColumn", PlainText(oldColumn.Value))
Regards,
Mona
User | Count |
---|---|
126 | |
87 | |
84 | |
75 | |
69 |
User | Count |
---|---|
214 | |
178 | |
140 | |
105 | |
83 |