Sorting Power Apps Gallery using - Dataverse (Not SP)

(0) Share

Report

Posted on by happyyear

633

Hello All,

Could you do me a favor?

I'm trying to sort a gallery with Dataverse as a data source.

Sort Icon :

UpdateContext({AppSortAscending: !AppSortAscending});

UpdateContext({SortColumn: "cr084_listprice"})

Used the below code in gallery Items property:

Sort(

If(

GalleryTab.Selected.Value = "All",

Filter(

Shoe_Inventories,

StartsWith(

Text(ProductCategory),

tbSearch.Text

)

Filter(

Shoe_Inventories,

StartsWith(

Text(ProductCategory),

tbSearch.Text

) && Text(ProductCategory) = GalleryTab.Selected.Value

)

If(

AppSortAscending,

SortOrder.Ascending,

SortOrder.Descending

)

But nothing happened. Could you do me a favor?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

Seems like you are missing your sort column before your sort order.

Was this reply helpful? Yes No
happyyear 633 on at

Like (1)

Report
Copy link

Link copied!

@ivan_apps Thank you for your comment. Could you please explain more?

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,680 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hello, @happyyear what @ivan_apps meant is this:

Sort( If( GalleryTab.Selected.Value = "All", Filter( Shoe_Inventories, StartsWith( Text(ProductCategory), tbSearch.Text ) ), Filter( Shoe_Inventories, StartsWith( Text(ProductCategory), tbSearch.Text ) && Text(ProductCategory) = GalleryTab.Selected.Value ) ), <COLUMN NAME HERE TO SORT BY, e.g Price, Category etc> , If( AppSortAscending, SortOrder.Ascending, SortOrder.Descending ) )

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No
happyyear 633 on at

Like (1)

Report
Copy link

Link copied!

@AhmedSalih Thank you. It is working well.
Sort(
If(
GalleryTab.Selected.Value = "All",
Filter(
Shoe_Inventories,
StartsWith(
Text(ProductCategory),
tbSearch.Text
)
),
Filter(
Shoe_Inventories,
StartsWith(
Text(ProductCategory),
tbSearch.Text
) && Text(ProductCategory) = GalleryTab.Selected.Value
)
),
ListPrice,
If(
AppSortAscending,
SortOrder.Ascending,
SortOrder.Descending
))

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sorry for the late response, looks like you got it working now

Was this reply helpful? Yes No