Answered

Issue with "Pending" leaves not showing in gallery filter

(0) Share

Report

Posted on by p_pravasi

Hello PowerApps Community,

I'm currently working on a leave planner app in PowerApps, and I've encountered an issue with the gallery filter. Specifically, when I click on the "Pending" button in the gallery, it does not show any leave records, even though there are records in the corresponding SharePoint list.

I have already validated that the SharePoint list contains leave records with the "Pending" status and that the data connections are correctly established.

I would appreciate any guidance or suggestions on why the "Pending" leaves are not displaying in the gallery when the corresponding button is clicked. Am I missing something in the formula or overlooking any potential issues?

Thank you in advance for your help!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

CU22081303-0 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, do any records show when you click any of the other buttons? I'm wondering if it is just Pending that has an issue, or if nothing is showing at all.

Could you share the OnSelect for the Pending button, as well as the OnSelect for one that works (if any work)?
The code for the Gallery's "Items" property would also be useful.
p_pravasi 9 on at

Like
a
(0)

Report
Copy link

Link copied!

It's working for all other status. It just has a issue with Pending status. Those 4 buttons are in gallery. Code for onselect property for the gallery is :
If(ThisItem.Filter<>_requestTypeFilter,
Set(_showDetails, false);
Set(_requestTypeFilter, ThisItem.Filter))
p_pravasi 9 on at

Like
a
(0)

Report
Copy link

Link copied!

This code has a problem :
Filter(
LeaveRequestDetails,
(RequestStatus.Value in ForAll(Split(
FilterGallery.Selected.Filter,
","
), {Result: ThisRecord.Value}))
)
Verified answer

CU22081303-0 150 on at

Like
a
(1)

Report
Copy link

Link copied!

Sorry this one is hard for me to troubleshoot. If the other buttons are working, I would suspect something is wrong with what value the Pending button is trying to add to the filter. Maybe capitalization or some unwanted quotation marks. I wish I could be more helpful, good luck!