Answered

Sort gallery by month.

(0) Share

Report

Posted on by nmlsanmiguel

Hello Guys,

New powerapps user here, I Would like to get help on how can I insert sorting codes on my current formula on my Gallery view.

If(
varDatacount < VarDelegationLimit,

Filter(
Filter(
'Luzon NAFS Dacion',
STATUS.Value = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank()),

FilterByNameDacion.Text in Title || FilterByNameDacion.Text in STATUS.Value || FilterByNameDacion.Text in 'ACCOUNT NAME'),
Filter(
'Luzon NAFS Dacion',
STATUS.Value = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank())

)

Hoping for your kind assistance.

Thank you and Stay Safe!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @nmlsanmiguel ,

The problem you have here is that while you have that in filter in the statement, the query is not Delegable, so you might as well do this

With( { wData: Filter( 'Luzon NAFS Dacion', STATUS.Value = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank() ) }, Sort( Filter( wData, FilterByNameDacion.Text in Title || FilterByNameDacion.Text in STATUS.Value || FilterByNameDacion.Text in 'ACCOUNT NAME' ), YourSortField, YourSortDirection ) )

You can try this as well

If( varDatacount < VarDelegationLimit, Sort( Filter( 'Luzon NAFS Dacion' STATUS.Value = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank() ), YourSortField, YourSortDirection ), Sort( Filter( 'Luzon NAFS Dacion' ( STATUS.Value = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank() ) && ( FilterByNameDacion.Text in Title || FilterByNameDacion.Text in STATUS.Value || FilterByNameDacion.Text in 'ACCOUNT NAME' ) ), YourSortField, YourSortDirection ) )

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
nmlsanmiguel on at

Like (0)

Report

Hi Sir, appreciate the help, but when I am trying the IF code you have shared, I can't find the Sort Field which was a Date column. Thank you.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

Hi @nmlsanmiguel ,

I am not sure what you mean - you just need to replace YourSortField with your field name (and also the direction)

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

Hi Sir, I am Still getting an error upon doing,

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@nmlsanmiguel ,

There is no Sort criteria in that code and I do not see any error lines - have you typed the full code in ?

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report
This code works for me! Thank you.

Would also like to know if how can I filter dates automatically for the current month? Thank you.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @nmlsanmiguel ,

Note this is not Delegable

Month(YourDateField) = Month(Now()) && Year(YourDateField) = Year(Now())

Was this reply helpful? Yes No
nmlsanmiguel on at

Like (0)

Report

oh no, How can I make it delegable? Thank you

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
@nmlsanmiguel ,

If you set up two dates with the start and end of the current month, you can query between them - First of month is

Date( Year(Now()), Month(Now()), )

Last day of month (a bit trickier)

If( Month(Now()) = 12, Date( Year(Now() + 1), 1, 1 ) -1, Date( Year(Now()), Month(Now() + 1), 1 ) - 1 )

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