cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
katrina_123456
New Member

Field on Edit Form not updating in SP list

Hi everyone!

 

I have this edit form in an app that updates 2 SP columns when submitted (ColumnA and ColumnB). My problem is that ColumnA is successfully updated but ColumnB is not. What's weirder is that this form is used in 3 separate screens. On the 1st screen, the 2 columns are updated successfully in SP. But on the other screens, the issue happens. I have already tried deleting the SP column and re-adding it, now it works on both the 1st and 2nd screen, but in the 3rd one the issue still happens.

 

The field doesn't have formulas or conditions, I just simply put the text "No" so when the form is submitted, the column will always be updated to "No"

katrina_123456_0-1619660407453.png

 

I hope someone can shed some light on this 😞 

5 REPLIES 5
Drrickryp
Super User
Super User

Hi @katrina_123456 

I am assuming that you show the highlighted control for a reason.  If this is the one causing the problem, then et the Default for DataCardValue108 to "No" and check the Update property of the card holding that control.  Make sure that it says DataCardValue108.Text.  If you don't want anyone to change it, set the DisplayMode property of the card to Disabled.  Also check in SharePoint that the Column type is single line of text. 

FYI, there are really only two important properties for a field on a form, one is the Default property of the control in that field's card and the other is the Update property of the card itself.   The rest are just bells and whistles.

Hi! I've checked the items you said and it's all correct. Also, the form is hidden so no one can change it.

katrina_123456_0-1619662330531.png

 

katrina_123456_1-1619662349841.png

 

Additional info: all the SubmitForm on the app on 3 screens works on my demo tenant copy. But this issue I posted just happened on the client side already. 

Drrickryp
Super User
Super User

@katrina_123456 

Try this test, set the Update property of Card to "No" and see what happens when you save it.  If that doesn't work, delete the card and then add it back again. Also, are you using SubmitForm() to save the data to your SPlist? 

Hi, I did all what you said, still doesn't work 😞 I also remove the data source connection and reconnected it but still not fixed. Yes, I'm using it to save data on SP list.

Drrickryp
Super User
Super User

Wow @katrina_123456 

I'm at a loss. Doesn't make sense.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,205)