with and forall for applying a code to several items

(0) Share

Report

Posted on by Antonioclk

hello,

i have a sharepoint list with the column "Students" where i store data in this format "name.surname@domain.com,name.surname@domain.com" and so on...

inside my gallery i want the names appearing in the format "Surname N., Surname N."

if the column Students had only one student i could just use this code

Proper(Last(Split(First(Split(ThisItem.Students,"@")).Value,".")).Value& " " &Left(First(Split(First(Split(ThisItem.Students,"@")).Value,".")).Value,1)&". ")

but considering there is many... i should first create a table with all the emails and then apply the code above to each of them

i guess i should use with and forall function, but i don't know how, could anyone help?thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Antonioclk ,

I think this is what you need

Concat( ForAll( Split( ThisItem.Students, "," ), With( { wName: First( Split( Value, "@" ) ).Value }, Last( Split( wName, "." ) ).Value & ", " & Left( First( Split( wName, "." ) ).Value, 1 ) & "." ) ), 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