You’re offline. This is a read only version of the page.
Announcements
402
Is there an easy way to group by a value in a field? I am pulling records from a SharePoint list based on month. In these records, there are emails. I would like to group, or select DISTINCT emails. Thanks for the help and information.
If you just need distinct email values, you can get all items, add a Select action after, switch the mapping of Select to a single textbox input & use the Email dynamic content in there. That will get only the email values in an array. Then in a Compose you can use a Union( ) expression on the Select outputs twice like Union(body(‘Select’), body(Select)) to get the unique email addresses.
If instead you need each record associated with each email or some kind of actual GroupBy, then there are a few more involved options:
Get distinct records: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Distinct-Records-amp-Counts/td-p/2191533
GroupBy with xpath: https://youtu.be/z5MxbwURV68?si=EU-oLHsBLQY2GfFr
Share
Report
All responses (
Answers (
