Unanswered

Filter and IF statement

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have a gallery of delegates in a training attendance app which filters by training centre but I would like to add some sort of IF statement / formula to remove delegates from the gallery once they have been marked as present, absent or late. At the moment, once a delegate is selected a new screen opens to an edit form to change a field to either present, absent or late and then navigates back to the gallery. Once these have been populated, I would like them to be removed from the gallery list as a way of tracking delegates who have not arrived or marked as present, late or absent etc.

Any help would be greatly received.

Thanks in advance.

Chris.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

g1224 348 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous
You can put the required filter in the gallery to avoid these status values like absent , present etc . On your screen where gallery is included , put a refresh(DatasourceName) on its Onvisible property.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @g1224
Thank you for your replay, I understand the refreash(DatasourceName) Onvisible property which will update my gallery list after editing changes, fantastic.

With regards the filter, I already have the following:
If(DropdownDay2.Selected.Result ="All", 'Training Tracker', Filter('Training Tracker', Centre.Value = DropdownDay2.SelectedText.Result))

So I need to add something like?
Filter(DataSource, ColumnName <> "TheVaueToExclude")

Thank you for your help and support.
Chris.
g1224 348 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes , use condition within the filter statement to avoid rows with specific values for a particular column .

Keep in mind the delegation impact on <> operator if your datasource is supposed to handle more than 500 rows .
Its explained here .
https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Yes this: Filter(DataSource, ColumnName <> "TheVaueToExclude") will work but bear in mind delegation warning for <>.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @phipps0218

Thank you. Can I use the the following as only need to see empty fields really:
!IsBlank(Column)

The column is a choice column so will I need to add the .Value function too?

As I'm new to PowerApps, how do I combine two filter functions together?

Thanks,
Chris.
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Please provide field names and what you want to filter then I can write the formula for you