Answered

District from Concat and Concatenate

(0) Share

Report

Posted on by as733y

224

I seem to be stuck trying to get Distinct emails from a collection and emails from a predefined string value combined together.

Below is what I have, but the Value is not recognized.

Distinct(Concatenate(Concat(colManagerEmails,Value," ;"),"; abc123@gmail.com"),Value)

Below is the OnSelect for a Button that Collects the colManagerEmails from all the SP items shown in Gallery1

Collect(colManagerEmails,Distinct(ForAll(Gallery1.AllItems,Office365Users.ManagerV2(ThisRecord.'aCreated By'.Email)),mail))

I'm trying to combine the colManagersEmails value in the Concat and then Concatenate the collection with a predefined string of Email values.

Can someone point me in the right direction?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @as733y

You use Distinct after fetching manager emails for the colManagerEmails collection. An second Distinct (first code block) is not necessary. Additionally, Concatenate will return a text value - resulting in the Value error.

Removing the Distinct should solve the issue:

Concatenate(Concat(colManagerEmails,Value," ;"),"; abc123@gmail.com")

In case the added text can also contain one of the already existing emails, you could (1) choose to add the predefined mails to the collection or (2) filter out the duplicates when running the first code block.

Option 1: adding predefined mails to the collection (moves logic to the collect function)

Collect( colManagerEmails, //Return only the unique mails Distinct( //Merge both tables Ungroup( [ //Fetch selected users' managers mails ForAll( Gallery1.AllItems, Office365Users.ManagerV2(ThisRecord.'aCreated By'.Email).mail ), //Add predefined emails [ {mail: "PredefinedMail1@email.com"}, {mail: "PredefinedMail2@email.com"} ] ], "Value" ), mail ) ) //Your first code block would look as follows: Concat(colManagerEmails, Value, " ;")

Option 2: Filter out duplicate values within the first code block (your collect function will remain as is)

With( {wPredefinedMails: "; abc123@gmail.com"}, Concat( Filter(colManagerEmails, !(Value in wPredefinedMails)), Value, "; " ) & wPredefinedMails )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
as733y 224 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM Thank you for taking time out to explain the 2 options. I went with option 1.

I'll have to read more about the Ungroup function, that seems to be the thing I was missing to connect everything else I had.