Powerapps Submit Combo Box record into Sharepoint Choice list column

(0) Share

Report

Posted on by Franklin_vaz

Hello experts,

Help me, i am a beginner developing my first canvas app.

Scenario:

1) I have a source SharePoint list "ActivityLog"

2) I am creating this app to get new form submissions from users.

3) I did multiple form entries; my app was successfully posting data into the Source Sharepoint list (ActivityLog).

4) Everything was working fine until I used a combo box control to get (searchable) multiple-choice inputs from the user to store inside my source SharePoint list (ActivityLog) column, which is a choice column.

Goal:

1) Get the list of values from a SharePoint List (TB_QueryCategory)

2) Use it in Combobox control.

3) Allow user to be able to choose multiple choices from the dropdown

4) Post the selected multiple-choice values to the Source Sharepoint List (ActivityLog), where the destination column is a Choice column

My Challenges:

1) Getting Delegation warning on the combo box although i filtered my incoming list of values from my Choice table (TB_QueryCategory) Sharepoint list. Filtered results would be less than 25 items though.

2) OnSelect SubmitForm function throws "Network error when using Patch function: An error occurred on the server"

Please enlighten me on what I am doing wrong here. Relying on your support. Thank you.

Tagging my known MVPs @RezaDorrani @ShaneYoung I am developing this canvas app mostly by watching your videos.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Franklin_vaz

The issue is this...you have an Items property that is providing a full record to the combobox from the TBL_QueryCatalog list.

Then, your Update property is providing a record with a Value column that contains a table of records with a 'Sub Category' column. SharePoint will not be able to use this.

A choice column needs a record with a Value column. In the case of a multiple select choice column, it needs a table of records with a Value column.

So, change your Update property to:

ForAll(ComboBox5.SelectedItems, {Value: 'Sub Category'})

This will provide the choice column with a Table (as made by the ForAll table function) with records that have a Value column.

Also, check your name for the Sub Category column in the formula. Out of three places referenced in your post, all three had different names for that column.

I hope this is helpful for you.
Franklin_vaz 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks @RandyHayes. You have helped me fix the submission error.

What would be the solution to avoid the delegation warning then?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Franklin_vaz

The delegation warning is coming from the combobox search feature. A combobox uses the in operator for its searching ability. However, there is nothing you can do to change that. If you have search enabled, it will give you a delegation warning. The only way around it is to pull what it wants to search into your app memory.

That would be worthless if you are only dealing with 25 records as you mentioned. In this case it is best to know that it is only a warning and that you have nothing to worry about.