cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TorreyFalconer
Helper IV
Helper IV

Multiple values to one Sharepoint column

Hello Hello, 

 

I need some help with what (to me) seems like a bit more of a complicated function.

 

I have a column in a Sharepoint list that is for "vehicle(s) involved". Right now it is a single-line column, therefore it appears in my Powerapp as such. 

I'm quite new to this, and would really like if someone could explain, in simple terms but great detail, what I need to do to be able to add multiple values to that item. I just need someone to be able to add one or more vehicles to that item, it appear in the one column in the Sharepoint list, and appear properly in the app as well. 

 

Anyone care to walk me through this?  Again- I will require step by step instructions! Thank you!!

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @TorreyFalconer ,

 

Do you mean you want to enter mutiple values to the SP list column?

To do that, you need a multiple lines of Text column, so that the value will show up in line.

1. Create a new column which type is Multiple lines of text in SP list.

2. Modify the Textinput control's Model from Single line to Multiline at the right properties bar in powerapps.

Annotation 2019-09-23 153438.pngAnnotation 2019-09-23 153606.png

Please try the workaround above, and check if your issue is fixed.

Best regards,

Sik

View solution in original post

8 REPLIES 8
RezaDorrani
Dual Super User
Dual Super User

Hi @TorreyFalconer 

 

If the vehicles involved is available as part of another list ( you have the list of item) - then in sharepoint just create a lookup column (multi select) to the vehicle list 

 

The form will then automatically handle your need

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

@RezaDorrani 

 

I don't know what you mean by "part of another list". I have one Sharepoint list, where there is a single column titled "Vehicle(s) involved" and is currently set to "single-line text". What should I change in the Sharepoint list? 

Hi @TorreyFalconer 

 

when you want users to enter vehicle(s) involved - is there a defined list of vehicles you want them to choose from or just give them the ability to randomly eneter muliple values?

@RezaDorranino list, they will fill out based on the scenario (custom)

v-siky-msft
Community Support
Community Support

Hi @TorreyFalconer ,

 

Do you mean you want to enter mutiple values to the SP list column?

To do that, you need a multiple lines of Text column, so that the value will show up in line.

1. Create a new column which type is Multiple lines of text in SP list.

2. Modify the Textinput control's Model from Single line to Multiline at the right properties bar in powerapps.

Annotation 2019-09-23 153438.pngAnnotation 2019-09-23 153606.png

Please try the workaround above, and check if your issue is fixed.

Best regards,

Sik

Is it possible to duplicate the list item (row) for the additional entries, without creating a new list item separately?

 

TitleSub-Item
1D1
1D2
1D3
2B1
2B2

Hi @RezaDorrani ,
What if we have defined list and user wants to select from combo box and update multiple values in list?

That is a great solution!  Exactly what I needed.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,937)