Tom, that works for items selected in gallery, but what if you want to filter the gallery by wether a column called "Team" contains User().Fullname. This column could either be a 'People' column or a lookup column which references a list of staff in another list.
I can only get the filter to work if the people column does not allow multiple values, for example:
SortByColumns(Filter(Participants, Team.DisplayName = User().FullName ), "Surname", If(SortDescending1, Descending, Ascending))
What I really need is the equivilent of:
SortByColumns(Filter(Participants, Team.DisplayName CONTAINS User().FullName ), "Surname", If(SortDescending1, Descending, Ascending))
I've tried every variation of find, search, filter, if and so on but as neither a lookup of people column are a text string the filter fails. I'm trying to find a workaround that would take the value of the people column and convert it to a text string which I could then use to filter the gallery.
I hope that makes some sense and thanks in advance!
I tried to put .Value at the end of the expression, but unfortunately I still receive the same error. "the property expects Text values, but this rule produces incompatible Record values"
Do you have any idea what else I could try?
@Daniel_Pipe, you could try filtering the teams first and then joining it with your list of participants on ID like so:
Filter(Child,'Parent'.Id in Filter(Parent_1, TextInput1.Text in DisplayName).ID)
Do you think this might solve your problem?
Sorry for the super late answer. Didnt have time to get back to this.
I understand what you want to do. And my first instinct with a people field (like the one in SharePoint I suppose) is that I would use a Lookup() funciton. But you can't use like contains in PowerApps. You could use like IsMatch() instead I guess but I could be wrong.
Let me know if it helped you out a bit.
I am experiencing a similar error. I am using the following expression "ThisItem.Counterparty.Value" for a label and the underlying data source is a sharepoint list lookup field looking up value from another sharepoint list.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications