Announcements
My input:1123 , 234 , 12376, 9876My output: ID 1123 23412376 9876not sure
Hi @ank3 ,
If this is what you want:
Then use the following code in your Textbox where you want to display the items in different line
//Here, TextInput1 will contain 123,345.... so on values //This will be in Label or Textbox where it will go in next line Concat(Split(TextInput1.Text, ","),Value,Char(10))
Note: The spacing in your separation will also be considered in new line
Hope this helps
for saving I'm using this: (can we edit in this itself)
for patching I'm already using this: (can we edit in this itself)
this is my collection: (can we edit in this itself)
Now can you tell me which step I need to modify to split the above text
I'm confused as why you used OnStart and OnChange
But what you can do it,
//For Save Button Patch( DataInput, ThisItem, { Name: Concat(Split(txt_ID.Text, ","),Value,Char(10)) } ); Collect(Table1_1, DataInput);
I basically want to add the data to new cell (every comma separated value to new cell in excel/sharepoint - attached screenshot below), and the above formula does not serve the purpose.
I'm getting error while using the above formula (attached screenshot below for reference):
Could anyone please help!!Thanks in advance for help.
@Ethan_R could you please reply?
Can you try the following code?
ForAll( Split(TextInput1.Text, ","), Patch( DataInput, Defaults(DataInput), { Result: ThisRecord.Value } ) )
thanks for the reply it is working now
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 239
