cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Issue with sharepoint list coumn of choice type

Hi,

 

I've a sharepoint online list which has customised powerapps for to enter/edit/copy/view entries. This list includes a couple of columns which are of "Choice" type and set to accept new values if the user wants put their text. This is working fine when entering or editing the data from classic/default sharepoint form. However, it's the case when doing the same via powerapps form. As they are cascaded dropdowns, i had to use powerapps form over the default form. I've set the update property of the data field to accept the selected value from the combobox control. The app doesn't show any errors ans is letting the user submit the entry. However, the data is not being captured in the SP list. When i switch back to the sharepoint list to view the entries, it's showing the required info missing(i've set the fields as manadatory). Funny thing here is, the values in these columns are just the same as in the cascaded combobox controls of the form. They're filtered depending the previous selection. Just to refine the matching and appropriate values.

SP_List Column settingSP_List Column setting

 

Form_LayoutForm_Layout

 

In the above form, the three fields Learning Category, Sub Category & Root Cause are linked to each other. Value list in learning subcategory and rootcause will be filtered using a temporary collection(with the same values from the choice columns of SP list). The update property has the value from the combobox.selected. I've tried every possible option and used all the help available over the blogs/community articles etc., but the issue still persists.

 

Can someone loook into this and advise me if it's a known issue or is there a possible fix?

 

Many thanks in advance!!

 

Cheers,

Sasi.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Issue with sharepoint list coumn of choice type

Hi @sasigouru ,

 

Are  Learning Category, Sub Category & Root Cause all choice type?

Or Learning Category, Sub Category are choice type, root cause is single line?

Could you please share more details of your formula expression of these three ComboBoxs' in your PowerApps?

 

Hope this could be helpful.

 

Best Regards.

Yumia

Highlighted
Advocate I
Advocate I

Re: Issue with sharepoint list coumn of choice type

Hi Yumia,

 

Thanks for responding.

 

Yes, all the three fields are of choice type with a combobox control in the custom form. However, I'm feeding the items for learning subcategory and root cause from a temporary collection(loads up every time the app starts) with the same values in the choices list in sharepoint. This is only to facilatate the filtering depending on the learning category selected by the user just show appropriate values. But, as mentioned the custom form is letting the user submit the form without any error. However, the data is not being saved in the backend.

 

I tried everything but couldn't make this work. So, i had to modify the column type in the SP list to single line text. It was a bit of pain to get this changed as i have 4 forms(view/edit/copy) linked to this SP list. Though my issue is resolved, there is definitely a problem with this column type. I made a test with a list having a single column of choice type(allow new values) and tried to enter my own value from the powerapps form, but it failed to do so.

 

Regards,

Sasi.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (9,498)