Cannot update Sharepoint list

[CedarTree]

Hello - trying to run an update query on a linked Sharepoint list in Access. I can manually change SOME of the rows, but not all (get a valid values/data integrity error). I'm not aware of any validations within my list, the field I'm updating is a text field, and I can't see any obvious difference between the rows I can edit versus the one's I can't. Please help!!! Thanks!!!

 

[MajP]

Can you provide the specific error message (Screen shot)? Does the existing list have any lookup columns?
Can you screen capture the properties on that field.

 

[CedarTree]

Thanks. All the same options as you have above (i.e., no requirements that the field be filled in, or unique values). No lookup fields. Here's the error:

 

[CedarTree]

Ha - turns out it wasn't a lookup field, but an unrelated choice field that was causing the issue.

 

[MajP]

Does the existing list have any lookup columns?

My first guess because these are a real PITA.

 

[GPGeorge]

Ha - turns out it wasn't a lookup field, but an unrelated choice field that was causing the issue.

Potentially irritating comment: SharePoint (and Dataverse) refer to these as "Choice" columns, whereas in Access, the term applied is usually "Lookup".

 

[MajP]

Potentially irritating comment: SharePoint (and Dataverse) refer to these as "Choice" columns, whereas in Access, the term applied is usually "Lookup".

Wrong. Sharepoint refers to both Lookup and Choice. Apples and oranges. Showing both choice columns and lookups.

 

[GPGeorge]

Wrong. Sharepoint refers to both Lookup and Choice. Apples and oranges. Showing both choice columns and lookups.
View attachment 117732

Thank you for the graceful correction.

 

[Isaac]

Hello - trying to run an update query on a linked Sharepoint list in Access. I can manually change SOME of the rows, but not all (get a valid values/data integrity error). I'm not aware of any validations within my list, the field I'm updating is a text field, and I can't see any obvious difference between the rows I can edit versus the one's I can't. Please help!!! Thanks!!!

Are there calculated columns anywhere on the row (not just what you're trying to update), are their lookup or People fields anywhere in the row, and do you have any Views based on this sharepoint table that have those.

 

[Isaac]

Sharepoint lists with Access in general is a real PITA.

If by any small chance you have the Time, Inclination, and corporate Charter to do so ... Look into making Power Apps with Sharepoint Lists instead.

 

[MajP]

By any small chance you have the Time, Inclination, and corporate Charter to do so ... Look into making Power Apps with Sharepoint Lists instead.

I am going this route now. Learning as I go.

 

[Isaac]

that's awesome - hey have you tried Power Automate yet? there is Desktop, but I'm thinking on a corporate account/server.
I made a few automate Flows before changing jobs and it was pretty cool. very good for updating stuff user-less, like ssis

 

[MajP]

Power Automate

A little. That is like a crazy enigma wrapped in a riddle. It is like someone explaining to me how bit coin works and after a while I am like "are you making this up? This cannot be real."