Two filters One Gallery pls help

(0) Share

Report

Posted on by Kmayes

792

Hi All

I have a SP dataset that has multiple columns but the two I'm concerned about are Signed Off Status(calculated column) and ID (unique identifier given by SharePoint to an item)

On a single gallery i want to filter by only showing items that are "Unresolved" from Signed Off Status and when searched in the text input box by ID.

I can get this to work on separate galleries using the following item filters

Filter('Weekly Vehicle Checks on TW Vehicles',SearchWeeklyFailure.Text = ID)

Filter('Weekly Vehicle Checks on TW Vehicles','Sign Off Status' = "Unresolved")

But i cant get this to work on one single gallery

Can someone assist with what im doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Try changing your Items property formula to the following:

Filter( 'Weekly Vehicle Checks on TW Vehicles', SearchWeeklyFailure.Text = ID && 'Sign Off Status' = "Unresolved" )

I hope this is helpful for you.

@Kmayes

Was this reply helpful? Yes No
Kmayes 792 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Thanks for responding i have just tried but i still doesn't seem to work 😞

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kmayes

You will most likely be having issues with the Calculate column. Is it a text type calculated column?

Was this reply helpful? Yes No
Kmayes 792 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes I have just checked and the calculated column is a text type column

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kmayes ,

Could you please try this codes to check if it works for your case?
Filter(Filter('Weekly Vehicle Checks on TW Vehicles', ID= Value(SearchWeeklyFailure.Text)),'Sign Off Status' = "Unresolved")
Hope this helps.
Sik

Was this reply helpful? Yes No
Kmayes 792 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft
Perfect this works! However is there a way that the gallery will visually show the 'Unresolved' items and then search by the ID, therefore is it a case of filter then search?

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kmayes ,

OK, I got you. Please try this:
If(IsBlank(SearchWeeklyFailure.Text), Filter('Weekly Vehicle Checks on TW Vehicles', 'Sign Off Status' = "Unresolved"), Filter(Filter('Weekly Vehicle Checks on TW Vehicles', 'Sign Off Status' = "Unresolved"),ID= Value(SearchWeeklyFailure.Text)) )
Sik

Was this reply helpful? Yes No
Kmayes 792 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft
Amazing thank you very much 🙂

Was this reply helpful? Yes No