web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue with sharepoint ...
Power Apps
Unanswered

Issue with sharepoint list coumn of choice type

(0) ShareShare
ReportReport
Posted on by 47

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.

I have the same question (0)
  • v-yuxima-msft Profile Picture
    on at

    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

  • sasigouru Profile Picture
    47 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard