Answered

Question on modern gallery

(0) Share

Report

Posted on by RosTravin

I'm testing modern gallery with modern controls. So filters seem to be working fine, in most cases, but if I hit "Refresh the source" button, some of fields are becoming blank. Sometimes it occurs after I submit changes to items.

Gallery Items:

If(IsBlank(SearchBoxUser_Purchase_3.Text) And IsBlank(SearchBoxItems_Purchase_3.Text), SortByColumns('Purchase tracking',"StatusNew",["In progress"]), Sort(Filter('Purchase tracking', SearchBoxUser_Purchase_3.Text in 'Requested by', SearchBoxItems_Purchase_3.Text in 'Order details'),ID,SortOrder.Descending))

Refresh button: Refresh('Purchase tracking')

Any help would be appreciated

Categories:

General Questions

2024-06-06_12-49-...

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 151,759 Most Valuable Professional on at

Like (0)

Report

Re: Question on modern gallery

Hi @RosTravin ,

Firstly, does it working a Classic Gallery ? If so, you might consider reverting to this until the Modern Controls are stabilised a bit better.

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

Re: Question on modern gallery

I had the same issue on Classic gallery, so I tried the Modern.

Was this reply helpful? Yes No
WarrenBelz 151,759 Most Valuable Professional on at

Like (0)

Report

Re: Question on modern gallery

@RosTravin ,

You are best staying with Classic- that exactly is ["In progress"] that you are sorting by ?

Was this reply helpful? Yes No
RosTravin 14 on at

Like (0)

Report

Re: Question on modern gallery

Yes, so In progress ones are always at the top of the list

Was this reply helpful? Yes No
WarrenBelz 151,759 Most Valuable Professional on at

Like (0)

Report

Re: Question on modern gallery

Hi @RosTravin ,

What are the other values possible in StatusNew ?

Was this reply helpful? Yes No
RosTravin 14 on at

Like (0)

Report

Re: Question on modern gallery

hi Warren, only other option is "Closed"

Was this reply helpful? Yes No
Verified answer

WarrenBelz 151,759 Most Valuable Professional on at

Like (0)

Report
Re: Question on modern gallery

Hi @RosTravin ,

Sorting that column descending will put "In Progress" on top. Also I think you need Or rather than And in the bottom search

If( IsBlank(SearchBoxUser_Purchase_3.Text) And IsBlank(SearchBoxItems_Purchase_3.Text), SortByColumns( 'Purchase tracking', "StatusNew", SortOrder.Descending ), Sort( Filter( 'Purchase tracking', SearchBoxUser_Purchase_3.Text in 'Requested by' || SearchBoxItems_Purchase_3.Text in 'Order details' ), ID, 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

Re: Question on modern gallery

Warren, thank you!

Was this reply helpful? Yes No