cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

using Split in Data table.

Hi All,
I want to use split function  and make this data come inside the data table. 

 

co1.PNG

 

I want the data inside the data table to look like.

 

Aaadhar

PAN

DL

10 certificate.

 

 

how can i do this  using Split ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi @Eben98 ,

 

if you are using a list form and the field is multiline/single line of test, please replace it with Listbox control by following the below steps:
replace the text with listbox.png

Now set the values to listbox as below:

ListItems.png

 

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

 

Regards,

Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Proud to be a Super User!

Regards,
KrishnaV
Business Applications MVP
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Hi @Eben98 ,

Split is used to text strings separated by a character (generally a comma) and turns them into a list.

What field do you have that you need to Split?

Highlighted
Super User III
Super User III

Hi @Eben98 ,

 

if you are using a list form and the field is multiline/single line of test, please replace it with Listbox control by following the below steps:
replace the text with listbox.png

Now set the values to listbox as below:

ListItems.png

 

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

 

Regards,

Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Proud to be a Super User!

Regards,
KrishnaV
Business Applications MVP
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

Highlighted

Hi @Eben98,

 

I see you liked my solution if you see it is not the right solution you want, please let me know where I missed you. So that I can help you better to fix the issue.

 

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

 

Regards,

Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Proud to be a Super User!

Regards,
KrishnaV
Business Applications MVP
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
Highlighted

Hi @KrishnaV , Thank you . But this is not the solution I am looking for. But I already finish this.

Normally I added a Data Table in its Items property I used Split( varViewIDProof, ",").Result.

 

the varViewIDProof is my variable where I store the data. Then in the Data Table field I passed my Result so I got it in the same way as u did with the multi line text.

 

Best Wishes,

Eben.

Highlighted

Hi @Eben98 ,

 

I am really happy that my proposal and your approach are inline. Thank you for your confirmation.

 

Regards,

Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.




I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Proud to be a Super User!

Regards,
KrishnaV
Business Applications MVP
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,207)