Unanswered

Help separating text box input data from power app to sharepoint list

(0) Share

Report

Posted on by DJH1

Need help trying to separate text from an user input text box on a power app form into a multiple line of text column in a sharepoint list. I've tried to use the Split function but now sure if I was using it correctly or placing it in the correct data card or if the data type being a table is causing the error.

Categories:

Building Power Apps

I have the same question (1)

All responses (6)

Answers (0)

madlad 2,637 Moderator on at

Like (0)

Report

Hi!

Are you just trying to submit the data from the text box to the SP list? Also, what split functions have you tried, and what happened with them?

The Split function breaks up a line of text into a table, based on a provided separator- it generally isn't needed to submit to a SP list text column, unless you're trying to format the text possibly.

Let me know!

Was this reply helpful? Yes No
DJH1 15 on at

Like (0)

Report

I have a power app form for a sharepoint list and their is a multi line of text column for a user to enter names it's currently displaying in the sharepoint list as (Doe, Jane Doe, John) I'm trying to have it not show all combined. I've tried using Split(Parent.Default, " ") for the default on the datacard, I get There is an error in this formula.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report

@DJH1

Do you want to display them similarly to how a gallery would?

The error you have is because the Default needs to be a text value, and you're providing a table value.

As long as you're just viewing the item(not updating), then a gallery should work, with the items property being the Split(Parent.Default, " ") you mentioned earlier.

Let me know how it goes!

Was this reply helpful? Yes No
DJH1 15 on at

Like (0)

Report

I'm trying to have the data from the app text box (which would be user entered names) sent to SP list but formatted so the names are not all combined but separate.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report

@DJH1 I see.

Just to confirm, do you want to make them separate SP list items, or have them be separate, but stored in one item on the SP list?

To do them as separate SP list items, I would try to combine the split() with some kind of ForAll() statement. With more details I could provide some more specific code.

As for keeping them separate but within one SP list item, I'm not sure if there is a way/what that would be. I would recommend keeping them together as text but just splitting whenever you need to display / use them. Maybe someone else has a way to do this?

Was this reply helpful? Yes No
DJH1 15 on at

Like (0)

Report

I was able to use a power automate flow to separate the names in the SharePoint list for the app.

Was this reply helpful? Yes No