Hello, I've tried finding an answer to this with no solid yes or no it can't be done. I have a Gallery I'm trying to Group By which works fine if I use an expression within the datasource the results are coming from. However, in this particular circumstance I need to filter based on a separate datasource within the current datasource filter. My first challenge was that the results produced a table, and I cannot filter based on a table. So, I thought I could use the Concat function in order to break down the results, which works. But, yet again, the gallery is still not filtering because it's more like an Or Or Or... statement since the results vary based on the user that's logged into powerapps. My formula is below.
Sort(GroupBy(Filter('All Asset List',Holder=Concat(ManagerHolders,Title)),"Holder","ManagerPortal"),Holder, Ascending)
In the screen cap below you can see I'm getting the separate results that I need:
My gallery filter works perfectly fine if I use the below manual code:
Sort(GroupBy(Filter('All Asset List',Holder="Test Sup" || Holder="Test Admin" || Holder="Owen Duckett"),"Holder","ManagerPortal"),Holder, Ascending)
Is there a way to get this to work since the results will in deed vary based on the user that's logged in, as I obviously can't manually type an Or statement to cover every possible outcome?
