Answered

Transfer data from collection to sharepoint list for multi-select inputs

(0) Share

Report

Posted on by alakshman

Hi,

I've created a custom form that allows you to add feedback first to a collections table prior to uploading to a sharepoint list.

Data is populating to the collections table correctly for all input fields.

However, when I try to transfer the collection table to a sharepoint list, two columns won't transfer over (surgeons and instruments); these two columns are multi select list box options.

Here is my current code:

Patch(
'Clinical Lab Notes',
ForAll(
FeedbackCollection As _col,
{
Title: _col.Title,
Date: _col.Date,
Location: {Value: _col.Location.Location},
Project: {Value: _col.Project.Projects},
Procedure: _col.Procedure,
'Cadaver Gender': _col.Cadaver_Gender,
'Cadaver Levels': _col.Cadaver_Levels,
'Cadaver Pathology': _col.Cadaver_Pathology,
Step: {Value: _col.Step.'Step Name'},
Feedback: _col.Feedback,
Instrument: {Value: _col.Instrument.Instrument}

Surgeon: {Value:_col.Surgeon.Surgeon
}
)
)

There seems to be something wrong with the "Instrument" and "Surgeon" syntax.

What needs to be fixed?

List box options:

Collections Table:

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @alakshman,

Your trying to Patch Instrument and Surgeon as a string into a MultiSelect column.
The Concat function concatenates the result of a formula applied across all the records of a table, resulting in a single string.

Instead of doing the Concat you just want to send the whole record with the Patch and not just a string.
e.g.

Patch( 'Clinical Lab Notes', ForAll( FeedbackCollection As _col, { Title: _col.Title, Date: _col.Date, Location: {Value: _col.Location.Location}, Project: {Value: _col.Project.Projects}, Procedure: _col.Procedure, 'Cadaver Gender': _col.Cadaver_Gender, 'Cadaver Levels': _col.Cadaver_Levels, 'Cadaver Pathology': _col.Cadaver_Pathology, Step: {Value: _col.Step.'Step Name'}, Feedback: _col.Feedback, Instrument: {Value: <ComboBox1>.Selected} Surgeon: {Value: <ComboBox2>.Selected} } ) )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

alakshman 71 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe
Thanks for the feedback!
Tried that and it didn't work unfortunately.

However got everything to work with a combination of spilt and concat function:

Patch(
'Clinical Lab Notes',
ForAll(
FeedbackCollection As _col,
{
Title: _col.Title,
Date: _col.Date,
Location: {Value: _col.Location.Location},
Project: {Value: _col.Project.Projects},
Procedure: _col.Procedure,
'Cadaver Gender': _col.Cadaver_Gender,
'Cadaver Levels': _col.Cadaver_Levels,
'Cadaver Pathology': _col.Cadaver_Pathology,
Step: {Value: _col.Step.Value},
Question: {Value: _col.Question.Question},
Surgeons: Split(Concat(_col.Surgeons, 'Last Name', "; "), "; "),
Instrument: Split(Concat(_col.Instrument, Instrument, "; "), "; "),
Feedback: _col.Feedback
}
)
)

Was this reply helpful? Yes No