web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combining email addres...
Power Apps
Answered

Combining email addresses from two sources

(0) ShareShare
ReportReport
Posted on by 94

Closest I could get was

 

ClearCollect(AllEmails, Distinct(Data1, email), Distinct(Data2,email))

 

This have me 2 tables within a table with the correct data.  Makes sense as Distinct returns a Result table. So I guess my question is how to reduce that down to one table with a column with emails for both Data1 and Data2?

Categories:
I have the same question (0)
  • cycle4passion Profile Picture
    94 on at

    Closer now, I used

     

    Concat(Data1, email, ",") & "," & Concat(Data2, email, ",")

     

    which gives me a string of emails comma separated, now trying to fit this into a dropdown. 

  • Verified answer
    cycle4passion Profile Picture
    94 on at

    I was able to piece it together. Included a separator between Data1 and Data2, and specified sortorder for each, and removed blanks created by trailing comma.

     

    Dropdown.Items = 

    Split(Left(Concat(Data1, email & ","), Len(Concat(Sort(Data1, surname, SortOrder.Ascending), mail & ","))-1) & ",-------," & Left(Concat(Sort(Data2, surname, SortOrder.Ascending), mail & ","), Len(Concat(Data2, mail & ","))-1), ",")

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard