cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Spawn10
Helper III
Helper III

How do I save multiple fields on a screen into one column in a SharePoint list?

I have a scrolable screen that has a number fields. I want to save all these fields as one column in a SharePoint list...is there a way to get about doing this in PowerApps? I want to submit all this data as one field in SharePoint.Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Spawn10 

 

If you want to pass all the fields as one column value, you can do a concatenation of all the Text Input/ Drop-downs and pass it as the attribute to SharePoint lIst:
 
Patch(SharePointListName, Defaults(SharePointListName),
    { Column1: Concatenate(
        TextInput1.Text," , ",
        TextInput2.Text," , ",
        Dropdown1.Selected.Result," , ",
        DatePicker1.SelectedDate," , ",
        .
        .
        . //to add all your columns
        )
    }
)
Please generate the value based on your requirement through Concatenate.
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2

Hi @Spawn10 

 

If you want to pass all the fields as one column value, you can do a concatenation of all the Text Input/ Drop-downs and pass it as the attribute to SharePoint lIst:
 
Patch(SharePointListName, Defaults(SharePointListName),
    { Column1: Concatenate(
        TextInput1.Text," , ",
        TextInput2.Text," , ",
        Dropdown1.Selected.Result," , ",
        DatePicker1.SelectedDate," , ",
        .
        .
        . //to add all your columns
        )
    }
)
Please generate the value based on your requirement through Concatenate.
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi yashag2255 ,

Thank you so much for getting me going in the right direction. This was extremely helpful.

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,171)