Excluding data when using ForAll and GroupBy

(1) Share

Report

Posted on by Markswan20

121

I have an app that allows users to delete data but this adds it to an archive.

The delete option patches the Sharepoint list for that record as NO under a column of visible.

Below is the current code but im struggling with where i can add the code to only show those records where Yes is in the Visible column

ForAll(GroupBy(Command,"GRS","_items"),First(Sort(_items, 'Log Date', SortOrder.Descending)))

Your help is very much appreciated

Mark

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Markswan20,

Try using the Filter function:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

The following code may work or you may need some trial-and-error:

ForAll(GroupBy(Command,"GRS","_items"),First(Sort(Filter(_items, Visible = "Yes"), 'Log Date', SortOrder.Descending)))

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.
Markswan20 121 on at

Like
a
(1)

Report
Copy link

Link copied!

1st attempt, amazing thank you 🙂
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

My pleasure! Glad you got it working. Thank you for the update.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.
Markswan20 121 on at

Like
a
(1)

Report
Copy link

Link copied!

Is it possible to use code in the Visible property to fulfil the same requirements?
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If the results are being displayed in a grid then toggling Visible would leave empty rows, unfortunately.

Also, by filtering on the Visible field in the code example, you may get a smaller dataset returned which would be more performant than returning all rows and then toggling visibility.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.