Unanswered

filter related to 2 lists

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to filter requests from a list related to another list called History of approvers Certificates

with the following formula:

For all(
Filter(
"Test History of approvers Certificates";
Status = "Not started" && Approver.Email = VarUser.Email
);
Filter(
'Proof of Evidence Request';
ID = 'Process ID'
)
)

but once I try to access the filter elements in the gallery it tells me that it is waiting for a text

why the elements are accessed in this way that gives error

example:

ThisItem.Value.ID

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

It is not clear to me what you are trying to do. It looks like you have a list 'Test History of approvers Certificates" that you want to filter by three conditions, one of which is present in a second list called ''Proof of Evidence Request'. If this is not correct, please explain.

Filter( "Test History of approvers Certificates"; Status = "Not started" && Approver.Email = VarUser.Email )

Will produce a filtered table of the original list. This list can then be filtered by a column called 'Process ID' provided that it exists in the first list and is the same as the ID in the second list. If you had a dropdown control with the items property 'Proof of Evidence Request', you could select the correct item in the dropdown control and modify the filter to

Filter( "Test History of approvers Certificates"; Status = "Not started" && Approver.Email = VarUser.Email && 'Process ID' = Dropdown1.Selected.ID )

to account for all three conditions.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp thanks for answering

I have 2 lists
list 1:
'Evidence request test'

list 2:
Certified Approver Test History

In list 1 I have a series of fields that I need to show in a gallery where the status field of list 2 is equal to "Not started" and the field Approver. Mail 2 list email equal to VarUser.Email

the relationship between the two lists is the ID field from list 1 and the 'process ID' field from list 2 which are the same

that's why i use
Forall(
Filter(
"Test history of Certified approvers";
Status = "Not started" && Approver.Email = VarUser.Email
)

so that the number of elements is equal to the previous filter
and use the following filter to display the items in list 1 based on the first filter in list 2
Filter(
'Evidence request test';
ID = 'process ID'
)

that is, if the first filter in list 2 returns 4 elements, it will be 4 elements shown in the gallery but from list 1

If I apply this formula in the OnVisible property it works, but a collection can only have 2000 items
For all (
Filter (
'Evidence of History of Approvers Evidence';
Status = "Not started" && Approver.Email = VarUser.Email
);
Collect (
colTaskspending;
Filter (
'Evidence request test';
ID = 'process ID'
)
)
)

I hope it is clearer