Split A Text Column By A Delimiter
Split A Text Column By A Delimiter Input collection: myContactNames16 FullName Email Johnson, Bruce [email protected] Field, Sally [email protected] Nyugen, ...
- Published
- Reading time
- 1 min read
Before you start
Is this guide for you?
- Best entry point
- Power Apps
- Time investment
- 1 min read
Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/split-a-text-column-by-a-delimiter/. Author: Matthew Devaney.
Split A Text Column By A Delimiter Input collection: myContactNames16 FullName Email Johnson, Bruce [email protected] Field, Sally [email protected] Nyugen, Sam [email protected] Waters, Laura [email protected] Noble, Jackie [email protected] Output collection: mySolution16 FirstName LastName Email Johnson Bruce [email protected] Field Sally [email protected] Nyugen Sam [email protected] Waters Laura [email protected] Noble Jackie [email protected] Solution code: // Create a collection
ClearCollect(myContactNames16, { FullName : "Johnson, Bruce" , Email : " [email protected] " }, { FullName : "Field, Sally" , Email : " [email protected] " }, { FullName : "Nyugen, Sam" , Email : " [email protected] " }, { FullName : "Waters, Laura" , Email : " [email protected] " }, { FullName : "Noble, Jackie" , Email : " [email protected] " } ); // Get split column by delimiter code
ClearCollect( mySolution16, DropColumns( AddColumns( myContactNames16,
"FirstName" ,First(Split(FullName, "," )).Value,
"LastName" ,Last(Split(FullName, "," )).Value ), "FullName" ) ); Code language: JavaScript ( javascript )
Tagged
Power Apps
Have a Microsoft 365 topic idea?
Share article suggestions, community session ideas, corrections, or real-world scenarios for future nextM365 learning notes.
Keep learning Microsoft 365
Explore more practical guides for SharePoint, Power Platform, Copilot Studio, migration, automation, governance, and security.
Continue learning
Related tutorials
Related questions
Related comparisons
Next action