Answered

Gallery not working in prod

(0) Share

Report

Posted on by RosTravin

Gallery is working fine in editing mode, when I use filters there are no issues. When I publish app and I use filters - gallery turns blank. I have already re-published app, cleared cache cookies, even repaired Edge. And I've tried another browser too. The Items formula is next:

/////////////////

If(
IsBlank(StatusBox.Selected.Value) And IsBlank(ReasonBox.Selected.Value) And IsBlank(UserBox.Value) And IsBlank(BOXDEVICENOTRETURNED.Selected.Value) And IsBlank(SerialBox.Value) And vFilterCheck = false,
Sort(EQPINVUA,Date,SortOrder.Descending),

Sort(Filter(EQPINVUA, Reason.Value = ReasonBox.Selected.Value || IsBlank(ReasonBox.Selected.Value),
Status.Value = StatusBox.Selected.Value || IsBlank(StatusBox.Selected.Value),
UserBox.Value in User Or IsBlank(UserBox.Value),
SerialBox.Value in Serial Or SerialBox.Value in 'Inventory №',
'Device was returned'.Value = BOXDEVICENOTRETURNED.Selected.Value || IsBlank(BOXDEVICENOTRETURNED.Selected.Value)
),
Date,
SortOrder.Descending
)
)

/////////////////

Issue appeared out of nowhere, and I have no clue how this is possible, when in developer mode it works, and in prod it doesn't.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @RosTravin ,

Try this format

Sort( Filter( EQPINVUA, Reason.Value = ReasonBox.Selected.Value || Len(ReasonBox.Selected.Value) = 0, Status.Value = StatusBox.Selected.Value || Len(StatusBox.Selected.Value) = 0, UserBox.Value in User || Len(UserBox.Value) = 0, !vFilterCheck || ( vFilterCheck && ( Len(SerialBox.Value) = 0 || SerialBox.Value in Serial || SerialBox.Value in 'Inventory №' ) ), 'Device was returned'.Value = BOXDEVICENOTRETURNED.Selected.Value || Len(BOXDEVICENOTRETURNED.Selected.Value) = 0 ), Date, SortOrder.Descending )

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

Was this reply helpful? Yes No
RosTravin 14 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I was able to make it work based upon your solution with a minor tweak.
Big thanks, you made my day!🤝

Was this reply helpful? Yes No