Power Platform Community Forum Thread Details

Good Afternoon,

I have been designing a Canvas app with a gallery that gets items from 3 SharePoint lists. Each list is for the status of a request(Pending, Active, Archived).

I have a "menu" gallery(MenuGallery) that is used to select between Pending, Active, and Archived and a drop down(LESortDrop) to filter based on a column in each SP List(Drop down items and column items are equal to each other). Based off that "menu" gallery and drop down selection my main gallery has the following code:

If(
 MenuGallery.Selected.KeyID = "ArcReq",
 If(
 LESortDrop.Selected.Value = "All",
 Sort(
 'Request Tracker Archive',
 'Choice Column'.Value, //Note actual column name is not actually Choice Column
 Ascending
 ),
 Filter(
 'Request Tracker Archive',
 'Choice Column'.Value = LESortDrop.Selected.Value
 )
 ),
 MenuGallery.Selected.KeyID = "PenReq",
 If(
 LESortDrop.Selected.Value = "All",
 Sort(
 'Request Tracker Pending',
 'Choice Column'.Value,
 Ascending
 ),
 Filter(
 'Request Tracker Pending',
 'Choice Column'.Value = LESortDrop.Selected.Value
 )
 ),
 MenuGallery.Selected.KeyID = "ActReq",
 If(
 LESortDrop.Selected.Value = "All",
 Sort(
 'Request Tracker',
 'Choice Column'.Value,
 Ascending
 ),
 Filter(
 'Request Tracker',
 'Choice Column'.Value = LESortDrop.Selected.Value
 )
 )
)

My issue is sometimes this code works and sometimes it doesn't. I have tried using multiple galleries each with their own source and using Visibility to show/hide the respective gallery but when I change the selection on the "menu" gallery the visibility would not update. The permissions seem to be fine as I can see the correct lists and data when I use the lists in separate galleries or if I change the selection of my drop down filter.

When I change the selection of the "menu" gallery and then change the item selected for the filter drop down, the gallery will update and show the correct data. If I then change just the selection of the "menu" gallery the items stay the same until I change the filter drop down. I can't for the life of me figure out why it will only update after changing the drop down.

I try to force a reset on the gallery, no luck. Change the order of what filter comes first(drop down or "menu" gallery), no luck. Any help would be greatly appreciated, thanks!

- James

Categories:

Building Power Apps

Hi @TurmanJames ,

Having three possible data sources will always cause issues, but try this (as you noted it is not a Choice column)

With(
 {
 wList:
 Switch(
 MenuGallery.Selected.KeyID,
 "ArcReq",
 'Request Tracker Archive',
 "PenReq",
 'Request Tracker Pending',
 "ActReq",
 'Request Tracker'
 )
 },
 Sort(
 Filter
 wList,
 LESortDrop.Selected.Value = "All" ||
 'Choice Column'.Value = LESortDrop.Selected.Value
 ),
 'Choice Column'.Value
 )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps