PowerApps | Patching Multi-Select fields, Date Pickers, Ratings, Sliders (7)

[@rafaelgomesUmbermash]

Thanks from Brazil, thats helps a lot!

[@andrewhess123]

Thanks for watch Rafael!

[@JonnyBadmoon]

Hi, as for the combo box that worked great for me, but when I use instead a List Box I find I cannot remove the error from the Patch where it's expecting a text type for a table. When configuring the Combo Box field in Sharepoint under Settings, the Multi-Line Text box configuration for the Sharepoint field does not seem to accommodate the List Box options selected from the Patch. I'm wondering if the Combo Box can really be a multi-select List Box that can save those multiple selections to Sharepoint in the same manner?

[@andrewhess123]

Hi Chris, Yes this is possible too, for a combo box to actually be a multi select listbox and then save those selections. Totally possible!

[@17avskadoo]

Though Combo Box allows multi select option. I am interested only in first 2 selection.
In your case you concatenated all selected values and patch that to a one column. But my need is to get FIRST 2 selection and path that to 2 separate columns.
Request you to guide me please.

[@andrewhess123]

Hi Akshay, this would take a video, much more difficult scenario. Let me write it down.

[@17avskadoo]

@@andrewhess123 Thanks:)😀
In my Patch I am using below code while adding new row. But you can see its too big logic and hard to execute in update record context.
Interim_1: Concat(FirstN(cmbIntrim.SelectedItems,1),displayName,";"),
Interim_2: If(CountRows(cmbIntrim.SelectedItems) > 1,
Right(Concat(FirstN(cmbIntrim.SelectedItems,2),displayName,";"),
Len(Concat(FirstN(cmbIntrim.SelectedItems,2),displayName,";"))
- Len(Concat(FirstN(cmbIntrim.SelectedItems,1),displayName,";"))
- 1
),""
),

[@LeonardoMarcansoni]

Helped me a lot! Thank u so much

[@ammarqadir8133]

We are patching value of comboBox what is the benefit of using collection here?

[@andrewhess123]

Just using collection to simplify the equations. No true benefit here in this example, just learning... but "collections are useful for when we want an in-memory store for data. This is particularly beneficial because it enables us to share data between the screens in our application."

[@andrewhess123]

this is one of my older videos.. try a different one. ruclips.net/video/lxzUIEaR4P4/видео.html&t

[@ammarqadir8133]

I get an error while patching the data, expected type is text and Table is found,

[@andrewhess123]

sounds like you are patching or submitting the combo box instead of the label

[@ammarqadir8133]

@@andrewhess123 YesI, true

[@joenice242]

I was waiting for how to update the amenities to an existing park.