Unanswered

Patch a Multi Select Choice type column in SharePoint List from Power app

(0) Share

Report

Posted on by AdityaDani

Hi fam,

I have an Edit Form named : 'Add/EditForm' , Data source for this is 'AppList'. So when i submit this the data is perfectly getting submitted to AppList.

Above image is the form which submits the data to AppList.

In this form i have a combo box(CAS Depedency Apps). The data source for this combo box is a different SharePoint List = "App_Name_List".

My requirement is to save whatever Text user enters in Application Name Text Box to be available for the user to select from the combo box dropdown.

For this i am using a Patch function for the OnSelect property of the save button like this :

"App_Name_List" is the Data Source for the CAS Dependency Combo Box , and "DataCardValue8" is the text box used for Application Name. This patch function works like this. See the next image.

Here you can see 2 new entries, gtesttt and newtest which i passed from Application Name text box(DataCardValue8).

The Real Issue : I still cannot get the new entries to show in the Combo box as the text was saved into the column but not into the choice options like this image :

Now i need a solution where i can patch the data right into this options so that it show up in the drop down.

Thanks and Regards.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AdityaDani

See https://youtu.be/g9ChYuTdNd4 at 5 min
AdityaDani 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply Drrickryp.

I have already referred to the same video earlier for achieving this.

But in my case my , my column 'Application Name' expects "TABLE" type. The reason why I've used the Table syntax in my formula in the 2nd image.

and i dont have an issue with patching it. As you can see my 3rd image :

my data is getting patched but i dont see it in the options.

i want to be able to select newly added records in the choice options.

hope I can get a fix for that.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AdityaDani

I came up with a solution but it is a work around. One problem is that the SharePoint list is patched but it doesn't update the combobox immediately as per your requirement. This work around does. In the screenshot, my list is called Sales5000 and the choice column is Status. The new item for the column is in the textinput box. It demonstrated the result of running the patch. On Order was added to the choices in the combobox. You may want to check how it works in your app. There are things I don't understand about how it works in updating the choice column inside SharePoint.
AdityaDani 54 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Hi randy can you please look at this?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AdityaDani

So my first question would be - why are you patching? This appears to all be in a form. You should be using the form to submit the information, not a patch.

Don't you want that the user type in the new value and then when they submit, it becomes submitted with that record?
AdityaDani 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the late response.

The DataSource for my Form is : 'AppList'
So, when I submit using the Submit() function it saves the data to 'AppList'.

As you can see the below Image, I have a Combo box - CAS Dependency Apps in the form highlighted by the arrow. DataSource for this Combobox is a different SharePoint List = "App_Name_List".
So, the user is able to select the data from that list and when i Submit it gets saved into 'AppList'.

Now coming to my actual requirement :
I want to save whatever Text user enters in Application Name Text Box to be available for the user to select from the combo box dropdown.

So, to achieve this I am using a Patch function for the OnSelect property of the save button like this :
The name of my form is "Add/EditForm", which I am using inside the submit() function.

"App_Name_List" is the Data Source for the CAS Dependency Combo Box , and "DataCardValue8" is the text box used for Application Name.

The data is getting patched into the column, but not as an Option, Since the column is a multi select choice type column in SharePoint , the patched data should be available to the user as an option to select from.

Rather it only saves the data on the column but not as an option for the Choice column. Like this :

Here you can see 2 new entries, gtesttt and newtest which I patched from Application Name text box(DataCardValue8) earlier from the OnSelect .

But still I cannot see those entries inside the Choices.