Unanswered

Combining items in SharePoint list with same title to send in an email

(1) Share

Report

Posted on by user47596

I am looking to automate an email to be sent. I have a SharePoint list being populated from a Power App. There is a column in the SharePoint list that includes a 'Title' based on when the Power App form was submitted. Every time the Power App form is submitted, I want to combine all list items with the same 'Title' together to be sent in the same email. Has anyone done anything similar before and can advise?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

CassioM 13 on at

Like (1)

Report
Copy link

Link copied!
Can't you just use the Filter Array action?

From the input:

[ { "ID": 1, "Title": "A" }, { "ID": 2, "Title": "A" }, { "ID": 3, "Title": "B" }, { "ID": 4, "Title": "C" }, { "ID": 5, "Title": "A" } ]

filter:

item()['Title']

This is the result:

[ { "ID": 1, "Title": "A" }, { "ID": 2, "Title": "A" }, { "ID": 5, "Title": "A" } ]

Was this reply helpful? Yes No
user47596 4 on at

Like (1)

Report
Copy link

Link copied!

I am not sure. The title is being dynamically generated each time the Power App is submitted, so the title is not predictable and I do not know how to hard code in a filter array in this way. I am hoping to create a condition where the flow will loop through the array of Titles, and if two titles equal one another, then append their data together to be sent into one email, but I am having trouble with this. Thank you for your response and help!

Was this reply helpful? Yes No
CassioM 13 on at

Like (1)

Report
Copy link

Link copied!
What about that?

Select Titles
Map:
item()['Title']

Unique Titles
Inputs:
union(body('Select_Titles'), body('Select_Titles'))

Loop input:
outputs('Unique_Titles')

Filter array
From:
variables('List')
Filter expression:
item()['Title'] is equal to items('foreach_Title')

Collect the result with a compose action outside of the loop:
Inputs:
body('Filter_array')

This is the result, an array of arrays grouping the records by Title:
[ [ { "ID": 1, "Title": "A" }, { "ID": 2, "Title": "A" }, { "ID": 5, "Title": "A" } ], [ { "ID": 3, "Title": "B" } ], [ { "ID": 4, "Title": "C" } ] ]

Was this reply helpful? Yes No