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

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,013)