Unanswered

Split from SharePoint list column

(0) Share

Report

Posted on by Liven97Kindo

Dear Microsoft Team,

I have a SharePoint list column named "Names" and I want to Split the values of the "Names" column inside a TextInput that's inside a Gallery to get multiple rows inside my Gallery, I tried to use as below but I'm getting an error msg data type: Table.

Split(PlainText(ThisItem.Names),"|")

is there any possible way or different method to split my data?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
So when using concat and placing results of that in a textinput its just going to jam all the words together, no line breaks etc so what you need to do, is in your gallery, place another gallery as an item, and make that gallerys items

Split(ThisItem.Names,"|")

Then place a TextInput inside this nested gallery and make ITS default

ThisItem.Result

this will give you

Was this reply helpful? Yes No
Liven97Kindo 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush
I'm pretty confused and lost about what you just said. I have no idea how to apply that and do the nested galleries. is there any possible way you can show me how to do it.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In your gallery, click insert, and select gallery. Then copy paste the code from above into it's items property, place a text inpu tinside it, and copy and paste the second code.

Was this reply helpful? Yes No
Liven97Kindo 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Works really well, but how about I want to have multiple text inputs to show multiple columns?

Was this reply helpful? Yes No
Liven97Kindo 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush
Is it possible to have multiple text inputs to show multiple columns?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

add more galleries, you can drop as many as you want in. Same as first one. And just arrange them however you want inside the original gallery

Was this reply helpful? Yes No
Liven97Kindo 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush Hi,

Is there any other possible way to do it by a single gallery. cause the nested gallery method is not working for me and I'm facing problems with the design and patching the records.

Was this reply helpful? Yes No