Share via

How can I Sort AND Filter a Gallery in PowerApps?

Anonymous
2023-11-29T11:16:01+00:00

Hello everyone,

I'm having some trouble getting the right formula to Sort AND Filter a Gallery in PowerApps.

Here is an example of a Filter Gallery I have created:

Here is an example of a Sort Gallery I have created:

The name of the SharePoint list is 'Overseas Travel Log'. I am trying to create a formula that merges both the Sort and Filter together. They work separately, but not together.

What I want is a formula that filters by user (first formula) and shows the newest (creation) date first (second formula). The first image is what I want, however the dates are shown oldest - newest. I'd essentially like this reversed so it shows the newest result first, as shown in the second image.

I hope this is enough context :)

I did look online, which suggested I do this: 'Sort(Filter(DataSource, FilterCondition), SortColumn, SortOrder)', but this hasn't worked:

Thanks all for your help :)

Katie.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-29T11:41:57+00:00

    Dear Katie.

    Good day!!

    I understand your concern, considering that this issue is related to sort and filter a Gallery in PowerApps, I would like to suggest you post your concern in the dedicated channel Microsoft PowerApps Community. We are sure that our experts from that team can address your query effectively and accurately.

    The reason I ask you to post a new thread is that in Microsoft Community, we have limited resources and very little knowledge about PowerApps queries, and in Microsoft PowerApps Community you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Tina | Microsoft Community Moderator

    0 comments