Submit form behavior - SharePoint List Multi-LineText

(0) Share

Report

Posted on by IncursioML1

Hi All

I have an app in which the submission works in which adds the record to a SharePoint List.

The SharePoint List has a field which is a multi line text but the form is a combo-box that connects to that multi-line text.

The combo-box allows multiple selections.

A question that came up is that when multiple items are selected and submitted, even though successful only adds the last selected item in combo-box to the field in the SharePoint List. My hunch is that regardless if I allow multi-select in that combo-box it won't work like how I'm expecting, unless I do some concatenation logic of looping through the combo-box and use that as a helper interface for users to submit to another field like example below.

1) Combo-box 1 = user picks A, B, C - post to SharePoint field Combo-box 1 (still posts C as 1 record)

2) Combined Text = does concatenated logic of "A,B,C" which then posts to SharePoint field Combined Text.

Is there another way to go about this that anyone can recommend? Still going to be a pain to report this since having to parse those strings later down the road, vs. just submitting 1 record with 1 input.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@IncursioML1

Change your Update property of the Datacard with the combobox to:

Concat(yourComboboxName.SelectedItems, Value & ",")

NOTE: This is assuming that the Items property of the combobox produces records with a Value column. If not, adjust accordingly.

Then, set your DefaultSelectedItems property of the combobox to the following:

Filter( RenameColumns(Split(Parent.Default, ","), "Result", "Value") !IsBlank(Value) )

I hope this is helpful for you.

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report
So the Concat worked putting in the Update property of the Datacard as you suggested.

The 2nd part though is coming up with an error on the !IsBlank function

Filter( RenameColumns(Split(Parent.Default, ","), "Result", "Value") !IsBlank(name) )

name there is the items in the combobox.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@IncursioML1

The Split function returns a table with a single column called Result. We are using the RenameColumns to change that from Result to Value. So, the result is a table with a single column called Value.

In other words, there is no "name" column.

You need to change that to Value. Beside that, given the Update property I gave you, you need it to be Value all the way through.

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report

I seem to still running into this problem on the DefaultSelectedItems regardless of how ever I set up the Update property. Would there be another naming convention that I am missing up on with the datacard?

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report
there literally was just a missing comma in there
Filter( RenameColumns(Split(Parent.Default, ","), "Result", "Value"), !IsBlank(Value) )

Was this reply helpful? Yes No