cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerApps not writing certain fields to sharepoint list

Hi folks,

 

I've got a SharePoint list called Events, which I am trying to make a custom form to populate. My app contains two data sources, the "Events" SharePoint list and another SharePoint list called "Event Sub-Categories", which filters categories and sub-categories in two drop down boxes in the app.

 

I have the drop down boxes working perfectly in terms of cascading drop boxes, but when I use a button to Submit my form, it submits everything except for the two categories that get their data from the "Event Sub-Categories" list. I am using the SubmitForm(SharePointForm1) code in my button.

 

The update property of both cards appears to be set correctly using the name.selected property, though I have tried .selected.result and .selected.value as well. Data fields also match the SharePoint list. I've tried all sorts, short of trying to collect or patch the data. Any ideas what could be going wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: PowerApps not writing certain fields to sharepoint list

Hi @v-yamao-msft - I've managed to resolve this.

 

The problem was that the SharePoint list I was writing into had the columns set as lookup columns looking at the lists of categories and sub-categories that I had made. 

 

I was able to resolve this when I deleted those columns in the list I intended to use for logging purposes and instead made them single line of text fields. 

 

PowerApps now writes back to these fields and is restricted by the drop down lists pointing at the other lists. 

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: PowerApps not writing certain fields to sharepoint list

Hi @FMKY 

 

Could you please share more details of your column type in your SP list you want to save data on PowerApp side?

Is it one lookup or what?

What formula expression do you use currently?

 

Best Regards.

Yumia

Highlighted
Frequent Visitor

Re: PowerApps not writing certain fields to sharepoint list

Hi @v-yamao-msft - I've managed to resolve this.

 

The problem was that the SharePoint list I was writing into had the columns set as lookup columns looking at the lists of categories and sub-categories that I had made. 

 

I was able to resolve this when I deleted those columns in the list I intended to use for logging purposes and instead made them single line of text fields. 

 

PowerApps now writes back to these fields and is restricted by the drop down lists pointing at the other lists. 

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,455)