Second screen filter

(0) Share

Report

Posted on by iagosalvadori

Hi everyone,

I have a sharepoint list in wich I have data of expensives. I need my app to do these:

1. The main screen with all expenses submitted (main screen1):

Anotação 2020-05-04 114208.png

Example: The user needs filter expensives per Center Cost.

On screen 1 there is a button that goes to screen 2 (Filters).

2. Also I want a second screen with a where users can filter the screen 1.

Anotação 2020-05-04 114242.png

Anotação 2020-05-04 114304.png

I define the local variable and I filter my table sharepoint with this variable, but it is not working that way.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@iagosalvadori

Put this code in the OnVisible property of your screen

Set(I_CC; "");; Set(I_CC; Blank());;

Then put this code in the OnSelect property of your filter button

Set(I_CC; TextInput1.Text)

Finally, put this code in the Items property of your gallery

Filter(Despesas; I_CC = Blank() Or 'Centro de Custo' = I_CC)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
iagosalvadori 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @mdevaney ,

I put in my screen 1 the code:

And put this code in the OnSelect property of your filter button (screen 2):
I put this code in the Items property of your gallery:
But when I make the selection on screen 2 (filters) there is no change in the gallery on screen 1

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@iagosalvadori

While testing you should only use this code in the Items property of your 2nd gallery. This will eliminate the possibility that the issue is in another criteria. Please do this.

Filter(Despesas; I_CC = Blank() Or 'Centro de Custo' = I_CC)

Question: What column type is Centro de Custo in SharePoint?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
iagosalvadori 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @mdevaney

I did the test just using this code in mt gallery (screen 1) and it didn't work.

The column is of type text:

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@iagosalvadori
In your original screenshot there was an error showing. Does it still appear. If yes, please share a screenshot of the message.

Was this reply helpful? Yes No
iagosalvadori 68 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@iagosalvadori

Error message. What does it say? Does it still appear?

Was this reply helpful? Yes No
iagosalvadori 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @mdevaney

I said that only the code in Items doesn't work:
I tried to filter through the center cost: E410 but it appears expenses from the center cost E430:

Collumn type 'Centro de Custo':

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@iagosalvadori
I will ask one more time, does the error message still appear? If yes, please provide a screenshot of it.

Was this reply helpful? Yes No
iagosalvadori 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @mdevaney ,

No error message appears. But the filter function does not work as shown in the reply above.

Example:

I want filter expensives center cost (Cost Center) = E410 but E430 record still appears in the gallery (Screen1)

Was this reply helpful? Yes No