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.
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!!
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.
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.