Unanswered

If there are multiple addresses, they are separated by spaces, commas, or semicolons in gallery; if multiple addresses are detected, all valid addresses are added to the recipients.

(0) Share

Report

Posted on by 1213

When a user adds recipients, the following checks are performed: Is the address a valid email? If there are multiple addresses, they are separated by spaces, commas, or semicolons in gallery; if multiple addresses are detected, all valid addresses are added to the recipients.

I used this code for it but the gallery name field gives an error (ThisItem.Osoite) (Osoite = expected text value)

ForAll( Split( Substitute(Substitute(Trim(VastaanottajaOsoite.Value), ";", ","), " ", ","), "," ), If( IsMatch(Value, ".+@.+\..+"), Collect(vastaanottajat, {Osoite: Split( Substitute(Substitute(Trim(VastaanottajaOsoite.Value), ";", ","), " ", ","), "," )}) ) )

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 155,632 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @1213 ,

Are you trying to do this ?

ForAll( Split( Substitute( Substitute( Trim(VastaanottajaOsoite.Value), ";", "," ), " ", "," ), "," ) As _Data, If( IsMatch( _Data.Value, ".+@.+\..+" ), Collect( vastaanottajat, {Osoite: _Data.Value} ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
goncalomelo8 on at

Like (0)

Report
Copy link

Link copied!
Hi @1213,

This is happening because you are sending a table (the output from the Split function) to the Osoite field, which is expecting a text value. To fix it, you can do as follows:

With( { SplittedEmailAddresses: Split(Substitute(Substitute(Trim(VastaanottajaOsoite.Value), ";", ","), " ", ","), ",") }, ForAll( SplittedEmailAddresses, If( IsMatch(Value, ".+@.+\..+"), Collect(vastaanottajat, {Osoite: ThisRecord.Value}) ) ) )

Have a great day!

Kind regards,
Gonçalo Melo

Was this reply helpful? Yes No
1213 4 on at

Like (1)

Report
Copy link

Link copied!

Thanks! I got it with that one!

Was this reply helpful? Yes No
goncalomelo8 on at

Like (0)

Report
Copy link

Link copied!

Glad to know that @1213. I would kindly ask you to mark the answer as the solution.

Cheers

Was this reply helpful? Yes No