@hnguy71
Can you explain why you would expect two records from that formula?
My assumption is that you would expect ID 1 and 2 to be in your collection - however, you will not get that because I believe you have a typo in your formula for ID 2. There you have ME@CompanyB.com - again, my assumption is that you wanted that to be ME@CompanyA.com
IF the above is correct that it was wrong, then your formula needs to adjust to this in order to get the results that you want:
Set(gvUserEmail, "Me@CompanyA.com");
ClearCollect(
colUserList,
{
ID: 1,
Review: Table(
{Name: "Myself", Email: "ME@CompanyA.com"},
{Name: "Person1", Email: "Person1@CompanyB.com"},
{Name: "Person2", Email: "Person2@CompanyA.com"},
{Name: "Person3", Email: "Person3@CompanyA.com"},
{Name: "Person4", Email: "Person4@CompanyB.com"}
)
},
{
ID: 2,
Review: Table({Name: "Myself", Email: "ME@CompanyA.com"})
},
{
ID: 3,
Review: Table(
{Name: "Person1", Email: "Person1@CompanyA.com"},
{Name: "Person2", Email: "Person2@CompanyB.com"},
{Name: "Person3", Email: "Person3@CompanyB.com"}
)
}
);
ClearCollect(
colMyAccess,
Filter(
Ungroup(colUserList, "Review"),
gvUserEmail in Lower(Email)
)
)
You need to ungroup the table to be able to filter on it like that.
I hope that is helpful for you.
