Unanswered

Filter items in powerapp by status in SharePoint

(0) Share

Report

Posted on by BDbadger

I have a SharePoint list with a PowerApp as a front end to process failed jobs. In my list "PO Contents" I have a Status column. I only want my power app gallery to show me items that are in Status "Failed". I really do not need the search function either.

Current Gallery fx:

SortByColumns(Filter([@'PO Contents'], StartsWith('PO-Number', TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report
Hi @BDbadger - something like this?

SortByColumns( Filter( 'PO Contents', Status = "Failed" ), "Title", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
BDbadger 37 on at

Like (0)

Report

Thanks, that didn't work. It seems to wipe out my gallery.

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report

@BDbadger - what is the field type for your Status column?

Was this reply helpful? Yes No
BDbadger 37 on at

Like (0)

Report

@Amik - it is a choice column.

Was this reply helpful? Yes No
Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report
@BDbadger,

change:

Status = "Failed"

to:

Status.Value = "Failed"

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
BDbadger 37 on at

Like (0)

Report

@Amik - That was it! Much Appreciated! Cheers!

Was this reply helpful? Yes No