How to filter again (on person column) the output from a Filter Array?

(0) Share

Report

Posted on by keepitsimple

Hello,

I have a SharePoint list called Items Log. Each item in the list is Assigned to a person (person column).

I have used Get Items to get the items from this list with a Filter Query criteria.

Since, filter query criteria cannot have hyperlink columns, I have used Filter array to apply more criteria.

Then, I have used Select and Compose to get the unique 'Assigned To' values in an array.

Next, for each of the unique 'Assigned To' persons, I want to filter the Items against their names and do further processing (like to send an email to each of these persons with a list of Items against their names).

To do this, I am trying to use a 'Apply to each' for each unique name and then filter again from the first Filter array to get the items for the person.

I am not able to get to the correct syntax of the values to be used in the second Filter Array so that I can have desired results. I tried various options but none of them worked.

If someone has already done this and can help, it would be great.

Thank You

All responses (6)

Answers (0)

keepitsimple 44 on at

Like (0)

Report

Re: How to filter again (on person column) the output from a Filter Array?

Hi @v-yueyun-msft ,
Let me try one more time to explain.
Step 1: Get Items
Step 2: Filter Array
Please let me know what should be the next steps after this Filter Array now to achieve the results of sending an email to each person in Assigned with the list of Items assigned to him/her?

Item Assigned To
Item1 Person A
Item2 Person B
Item3 Person A
Item4 Person C
Item5 Person C
Item6 Person A

I want to send email to each of these persons with their list of items.
The email to Person A should have Items 1, 3 and 6.
The email to Person B should have Item 2.
And the email to Person C should have Items 4 and 5.

Thanks
v-yueyun-msft on at

Like (0)

Report

Re: How to filter again (on person column) the output from a Filter Array?

Hi , @keepitsimple
Thanks for your quick response! Sorry i may misunderstand your need ...
According to your description, you have a URL Column and you want to filter this column in Filter Array action.
If possible , can you give me some sample json you have and the end result you need in your side so that i can help you better!!

Best Regards,
Yueyun Zhang
keepitsimple 44 on at

Like (0)

Report

Re: How to filter again (on person column) the output from a Filter Array?

Hello @v-yueyun-msft ,
Thanks for putting so much of the details. However, it is still missing something.
In my flow, I need to use a Filter Array just after the Get Items to further filter out the output from Get Items. (My list has a URL column. URL columns cannot be used in the filter query of Get Items, therefore I need to do a Filter Array after Get Items.)
It is because of this first Filter Array I am not able to get to the right options to be used in the second Filter Array (that is within the Apply to each loop).

Regards
v-yueyun-msft on at

Like (0)

Report

Re: How to filter again (on person column) the output from a Filter Array?

Hi , @keepitsimple
Thanks for your quick response! This is my test SharePoint List:

This is my flow:

And for the AniyaZhang1 , i send this email :

(1)The "Get irtems" and "Select" action:

(2)The Apply to each action:

Best Regards,
Yueyun Zhang
keepitsimple 44 on at

Like (0)

Report

Re: How to filter again (on person column) the output from a Filter Array?

Hi @v-yueyun-msft ,
Your understanding is partly correct.
I want to filter the output from the first Filter Array (there is a Filter Array just after my Get Items), for each of the unique Assigned To value like explained below.
Item Assigned To
Item1 Person A
Item2 Person B
Item3 Person A
Item4 Person C
Item5 Person C
Item6 Person A

I want to send email to each of these persons with their list of items.
The email to Person A should have Items 1, 3 and 6.
The email to Person B should have Item 2.
And the email to Person C should have Items 4 and 5.
I hope it is clearer this time.
Thanks
v-yueyun-msft on at

Like (0)

Report

Re: How to filter again (on person column) the output from a Filter Array?

Hi , @keepitsimple
According to your description, do you mean you want to filter the displayName in your array?
This is my sharePoint list :
This is my flow which is similar to yours:
This is my Compose action output :
If we want to filter this array based on the [DisplayName] field or other fields . We can just use the FIlter Array action:
item()?['DisplayName']

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang