Combining Distinct and Filter with ForAll in a gallery

(0) Share

Report

Posted on by PA-JvdP

Hi everyone,

I'm struggling with the following problem:
I have a table which looks like this:

ID	Name	Value	Status
1	Blue	75	Success
2	Green	22	Fail
3	Red	12	Success
3	Red	20	Success
3	Red	16	Success

In my gallery, I'm using the following code on the Items property to get a list of names of the distinct ID's:

ForAll(
Distinct(DataSource, ID),
LookUp(DataSource, ID= Result)
)

This results in a gallery as such:

1	Blue
2	Green
3	Red

However, I would like to also filter this gallery on the Status column, only displaying the records that have the Status 'success'.

How do I combine a Filter statement with my code above?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @PA-JvdP ,

As below with a bonus column adding up the Value column

AddColumns( GroupBy( Filter( 'Order pdf AI outputs', Status = "Success" ), "principalsOrderNumber", "Data" ), "Items", CountRows(Data), "Total", Sum(Data,Value) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
PA-JvdP 43 on at

Like (0)

Report

Unfortunately, this leads to other problems. On the OnSelect property of the navigation icon in my gallery, I have this formula:

Set(varGetDocument, PowerAutomateName.Run(Gallery.Selected.SharePointIdentifier).result)

However, in this formula I get the error "Name isn't valid. 'SharePointIdentifier' isn't recognized."
I'm guessing this is because the SharePointIdentifier column wasn't given in the Items formula you suggested. I tried adding it as another AddColumns argument:

"SharePointIdentifier",
Data.SharePointIdentifier

But this gives me another error: "Invalid argument type (Table). Expecting a Text value instead.".
How can I insert the SharePointIdentifier to the grouped data as a column?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
@PA-JvdP ,

You can use

AddColumns( GroupBy( Filter( 'Order pdf AI outputs', Status = "Success" ), "principalsOrderNumber", "Data" ), "Items", CountRows(Data), "Total", Sum(Data,Value), "SharePointIdentifier", First(Data).SharePointIdentifier )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No