Answered

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)

Sort by

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

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
BDbadger 37 on at

Like (0)

Report
Copy link

Link copied!

@Amik - it is a choice column.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

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

Was this reply helpful? Yes No