cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

Hi Scott,

I set it 'Array'

Thank you

Flow05.JPG

Highlighted
Advocate II
Advocate II

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

@Codered

 

Ok cool, hmm i see that you initalize the array under the name 'EmailArray' but in your other posts in your screenshots you reference it as 'AssignedToEmailArray'

 

How is the name being referenced on your 'Append to Array variable' ? It should be from a drop down. Also in your SharePoint list is there a column named 'Assigned To' that is a person column?

Highlighted
Regular Visitor

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

Hi Zach,

Now, i created new flow from blank. So everything is new now.

i set initalize the array under the name 'EmailArray' and the value: 

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

Flow06.JPG

Flow07.JPG

Yes, in sharepoint list i have a column name 'Assigned To' that is a person column.

 

Thank you

Highlighted
Post Prodigy
Post Prodigy

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

Hi Kris,

 

Excellent works this is, thanks for the solution and thanks to Gautmish to post such question.

 

 

Highlighted
Post Prodigy
Post Prodigy

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

@gautmish@ZachRoberts

 

I am able to make this flow to work with your question and solution. Below is the screenshot of the email I receive.

Capture.PNG                                                              The Email Body screenshot you shared had borders and background color added. How can I display task list information in a table based format. I just want to add borders between columns and cells so readability can improve more, basically a table layout with borders. If anyone can help, that would be great. Thanks.

Highlighted
Advocate II
Advocate II

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

@dmistry


I added HTML  to my outlook email that is sent which styles the table.

 

In the body part of the email i have the following:

 

<!DOCTYPE html>
<html>
    <head>
        <style>
           body {
                font-family: Arial, Helvetica, sans-serif
            }
            table{
                font-family: arial, sans-serif;
                border-collapse: collapse;
                width: 100%;
            }
            td, th {
                border: 1px solid #dddddd;
                text-align: left;
                padding: 8px;
            }
        </style>
    </head>
    <body>
        <h1>Daily Task Report</h1>
        <table>
            <tr>
                <th>Section</th>
                <th>Task Name</th>
                <th>Due Date</th>
              <th>Comments</th>
               <th>Link</th>
            </tr>
            **PLACE OUTPUT FROM JOIN HERE**
        </table>
</body>
</html>

Make sure to place the output from the JOIN in your flow in the spot in the code above.

You will also want to make sure you set your outlook step in your flow is HTML to 'Yes'

 

 

Thanks,

Zach

Highlighted
Post Prodigy
Post Prodigy

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

@ZachRobertsthanks a lot for the help and getting back so quickly.

 

Can you please share info on what is OUPUT from JOIN? In the send an email I do have Output added in the body of the email. Are you referring to that Output? If not can you share screenshot please, will be very helpful. 

Highlighted
Post Prodigy
Post Prodigy

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

@v-xida-msft

Hi Kris,

 

Need your help here. I have the same flow setup on my environment with the help of your solution. 

In addition to the columns of OOTB Task list, I have 4 custom choice columns as Guiding Document (Guiding_x0020_Document), Brand Name(Brand_x0020_Name), Investor and Document Section (Document_x0020_Section). So as depicted in your solution, I added following expression to include that in email that's sent out:Brand Name:>> item()?['Brand_x0020_Name']?['Value']  

 

Similarly I added three more expressions for each choice columns making sure their internal names are right. Unfortunately flow fails and I see below error in select action.

SelectAction.JPGFlowFailed.JPG

 

As soon as I take those custom columns off the select action, the flow then works and sends email out. So I belive it has to be something wrong with Expression formula. I also tried dragging and  dropping data value card for each columns but then flow adds an apply to each block around select action and then flow runs infinitely.

 

@gautmish@ZachRoberts@Codered@ScottShearer@fzer0 if you guys can help on this, that would be very helpful. I am going nowhere with this, unable to fix, hoping you guys can help. I am simply using the solution provided on this question , the only difference bing additional 3-4 choice columns and its failing. The moment I take those column off of select query, flow works fine then. Hoping you guys can help me here, thanks in advance.

Highlighted
Post Prodigy
Post Prodigy

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

@v-xida-msft 

Just following up, any update on this, need help on this please.

Highlighted
Advocate II
Advocate II

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

@dmistry

Looks to be an issue with the Guiding Document field? Atleast the error screenshot attached in your post is calling this field out. 

 

Are you able to only remove this field and the flow to complete successfully? 

Highlighted
Post Prodigy
Post Prodigy

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

I have to take off Brand Name, Investor, Guiding Doc, Document section to get the flow to work. @ZachRoberts

Highlighted
Advocate II
Advocate II

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

@dmistry

 

Missed this reply - I have attached screenshots below of my select statement and then the join that is following it, the join is likely not needed as it adds a div tag to the select. Below that screenshot i have the output from the join added to the html of outlook message.

 

select_joinpng.pngjoin-output.png

Highlighted
Advocate II
Advocate II

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

What types are those columns on your OTB task list? Strings, number?

 

Do some of those columns have empty fields? I believe that will cause this flow to fail as well. 

Highlighted
Post Prodigy
Post Prodigy

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

They are custom choice columns and no they are not empty in the task list. @ZachRoberts

Highlighted
Post Prodigy
Post Prodigy

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

Thanks. Can you send a full screenshot of the second screen grab you shared, I just want to see how you have surrounded Output with table and br tags, thanks again.

Highlighted
Advocate II
Advocate II

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

Highlighted
Post Prodigy
Post Prodigy

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

I follow now, appreciate the help.

Highlighted
Advocate II
Advocate II

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

@dmistry

 

Have you tried the expression below for the new columns?

 

item()['choicefieldname']?['Value']
Highlighted
Post Prodigy
Post Prodigy

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

@ZachRoberts yes for Brand Name, I am using the following: item()?['Brand_x0020_Name']?['Value']

Highlighted
Advocate II
Advocate II

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

@dmistry

 

hmm ok ill try to replicate on my end with a choice field and see if i run into the same issue, ill let you know what I find!

 

Thanks,
Zach

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Users online (6,444)