I'm trying to filter a gallery by the current user of the app which at the same time is the supervisor of the agents that should appear on the gallery (each agent has a dedicated ticket).
The Supervisor information is taken from a second dataset.
Therefore, I set the "Items" attribute of my Gallery with the following formula:
Filter(
Sort(
Dataset1,
'Status (TicketStatus)'.Value,
SortOrder.Descending
),
LookUp(
Dataset2,
AgentDataset1= Agentdataset2
).Supervisor=AppUser
)
However, since each supervisor has several agents under his/her lead, the formula retrieves a table that does not filter the Gallery.
But I need more specific to give you your exact filter. but the above is how you want to do it (structurally)
Your issue is you are literally joining the two together incorrectly because of your lookup
If this helps please mark as such and maybe a like thanks!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
121
Share
Report
All responses (
Answers (
