Workflow that would loop through items, send all pending items for each assignee in one emailed

[Yemata]

I am out of ideas, cant figure out a way to set up a workflow. I have a task list. I am trying to set up a workflow that would loop through items, send all pending items for each assignee in one email, so each user with pending item gets one email with list of pending items 

Each user`s email would look like 

You have pending items,...please see link to the pending items listed below.  

Item Title : Title , Link: Link to item 

Item Title : Title , Link  Link to item 

Item Title : Title , Link Link to item 

Item Title : Title , Link Link to item 

...

I tried using arrays  but the logic got confusing, please if anyone have any input I would appreciate it. 

@DAllen365, @AnPhamEFL , @ScottShearer

@Pstork1

[SudeepGhatakNZ]

@Yemata ,

1) Add get items action to get all items from the list

2) Use a Select action to select the columns that you want in your email

3) Use Create Html Table action to create a table. Your input of this action will be the output of Select action above

4) Provide the output of Create HTML table action in your email.

[Yemata]

Thank you for replying. Following your steps, how do I get the emails for the user and send them the list of items that is assigned to them?

[SudeepGhatakNZ · Accepted solution]

Couple of additional steps needed there to retrieve a set of unique users.

This video explains how you can achieve that. He is using excel instead of Sharepoint but the concept is the same.

Send Unique Emails with HTML Table using Data from Excel #PowerAutomate - YouTube

[Yemata]

Okay, I am checking it now. Thank you. 

[Yemata]

@SudeepGhatakNZ Thank you so much it looks I am one step away from achieving this, appreciate the help. I am having one issue and I think it might be my expression in the fitter array, I am using the user`s email in both select and filter array action @item()?['ASSIGNEDTO/Email']. The filter array is returning empty, so I get the emails but with no data.

.   

[SudeepGhatakNZ]

Can you show me the raw inputs of the Filter array? and output of your union?

[Yemata]

the input and output of the compose action is the same, seems like the Select action is passing one instance of each email to the compose action. 

[SudeepGhatakNZ]

Is the issue sorted?

[Yemata]

@SudeepGhatakNZ  I am still not getting an output from the filter array. 

[SudeepGhatakNZ]

[Yemata]

@SudeepGhatakNZ  The output is different, it is returning it differently for the current item. please see the picture here 

 

[SudeepGhatakNZ · Accepted solution]

There you go, that is why you are getting no matches.

You need use proper selectors to pick the values you are comparing.

The value form the variable can be selected as:

body('action name')['value']