microsoft flow get all items with distinct Assigned to (User and group) filed

[gautmish]

Hi

I am creating a flow to get all the item assined to a single user and send an email to that user with all the item detail .

I dont want to send separate email for each task .

Could you please help me with any option . 

Thanks

Gautmish

[Anonymous]

@ZachRoberts appreciate the feedback, Just FYI, I am using the same flow solution provided on this thread. The only diffference being, I have three additional choice drop down columns and I want to include them in the select query so its rolled out in email body.

Thanks again.

[Anonymous]

@ZachRoberts, one question, in my case task description contains about 6-7 lines of text so description columns takes up most portion of table in terms of width. Can we restrict the size of such column or maybe apply some word-wrap, padding etc. Please advise, thank you.

[Anonymous]

@ZachRoberts, I have got this to work. Simply changed the expression formula from item()?['Investor']?['Value'] to item()['Investor']?['Value']

[fzer0]

Is there any way to extract all 'AssignedTo' emails for tasks which are assigned to more than one user?

[ovis2018]

Has anyone figured out how to correct the error for Append to Array?  I'm getting the same error as others mentioned in this post and have checked all the settings suggested with no such luck.  See error below:

[Anonymous]

@ovis2018  what is the value expression of apend array action? Please share screenshot

[ovis2018]

Hi @Anonymous  - please see below.  "L3EtPOwner" is a people/group SP column, not allowing multiple selections, and "show field" is set to name (with presence).  "L3Owner" is a people/group SP column, not allowing multiple selections, and "show field" is set to email.  I did try using "Email" as the appendage in an earlier test run and got the same error messages as previously posted. 

Thanks! 

[Anonymous]

@ovis2018 , keep show field to "name with presence" and you need to change the formula, your formula is wrong.

first(item()?['LE3towner'])?['Email'], that should work.

[ovis2018]

@Anonymous  - wish that worked but still receiving the "looking for array" error - see below.

Used the entry: 

Spoiler

first(item()?['L3EtPOwner'])?['Email']

[Anonymous]

I think, I had the same issue where I had to delete the formula and re-add it again, make sure your AssignedTo column has users added, please share updated screenshot of the formula you have entered and list view as well if possible.

[ovis2018]

Thanks. I tried deleting the action, readding, and inputting the formula mentioned earlier and received the error below.  One item of note...I'm not using a SP tasklist but a regular SP list.  With that, I don't have an "assigned to" column but am referencing a people/group column added to a regular list.  Does that make a difference in how the formula should be setup?  

[ovis2018]

@Anonymous  --update --

I recreated the flow and am seeing some positive changes in the errors I'm now receiving...the value is the first letter of the first name of the individual listed in "L3EtPOwner".  Any thoughts to the changes necessary to the expression with this new finding?

Current expression for the Append to array variable --> 

first(item()?['L3EtPOwner']?['Email'])

[ovis2018]

@Anonymous  okay...getting further along the workflow, but still erroring with the array. I'm getting successful tests through the Do Until, Get Items 2, and on Filter Array (within the Do Until) I'm getting an InvalidTemplate error - see below:

[ovis2018]

Hi @Codered  - were you ever able to figure out the fix to the "Append to Array" error? 

Thanks!

[Anonymous]

I am not able to understand the algo behind the approach suggested . Can someone explain what first() and union() is used for here

[Anonymous]

@Anonymous  First() returns the first element in the array or string passed in.

Union (): Returns a single array or object with all the objects that are either in the array or object passed to this function.

[Anonymous]

@ovis2018 I hope you can forgive me for replying on this so late, so sorry.

Actually I ran into exact same issue when I was deploying flow in production and same error was showing up. 

In my case the people picker column allows People and Groups. Once flow failed in production I went into check config for Dev environment's people picker settings. All i had to is, allow multiple selections for the people picker column and the flow then works. 

So it seems flow won't read first index of the element if people picker column is not set to allow multiple selections.

[Anonymous]

@Anonymous 

@v-xida-msft 

This is a great post - thank you for very detailed instructions. 

I've followed them and it works GREAT.

EXCEPT - While each email contains just a list of items assigned to the email adressee, each email is sent the number of times that matches the number of items in the list. For example, if a user has 3 items assigned to them, they receive 3 (identical) emails that each contains a listing of the 3 items. Another user that has 1 item only receives one email with his assigned item. 

Did i miss something obvious?

[Anonymous]

@Anonymous  Please share the screenshots of your flow with an expanded view of each action, might be the positioning of send an email action needs to be updated or the skip expression afterwords.

[Anonymous]

I first tried the flow on my existing list and it was sending out multiple emails, just like I described. Then I specifically set up a task list just like in the example provided and made sure to follow the example verbatim. Still the same thing: flow works but sends multiple emails to each recipient. But at least each email contains a full list of items assigned to that recipient, which is pretty great in itself. 

I appreciate any and all help. 

Here are screenshots of my flow: