Forum Discussion
MartaGM
Oct 21, 2021Copper Contributor
Blank fields when editing an existing list element
Please, I need someone's help. I have several lists in different sharepoint that worked as expected until a few days ago. Since then, when I try to edit an existing element in any list (I get the...
MartaGM
Oct 21, 2021Copper Contributor
Hi Eva. Thanks for answering me.
I don't really understand what you are saying but I have the same problem in a Team where I'm the owner and the only member (is the one that I use to try things before updating the ones with other people), and I haven´t change anything there that I remember
I don't really understand what you are saying but I have the same problem in a Team where I'm the owner and the only member (is the one that I use to try things before updating the ones with other people), and I haven´t change anything there that I remember
MartaGM
Oct 21, 2021Copper Contributor
I have just realized one thing, eventhough all the fields seem to be blank when editing, only the ones with date format maintein their value when saving.
I tried creating a new list with 2 columns (number and text) and it worked fine, then I add another column with date format and the same problem appeared.
I really don't understand anything. Is any of this ringing a bell for you?
Thanks again.
best regards, Marta
I tried creating a new list with 2 columns (number and text) and it worked fine, then I add another column with date format and the same problem appeared.
I really don't understand anything. Is any of this ringing a bell for you?
Thanks again.
best regards, Marta
- Eva VogelOct 21, 2021Steel Contributor
Hi Marta, pls. check your regional settings, like language and currency settings in your M365 Account.
Here attached 4 you to little films: first to check your permissons level in SharePoint( user15 is a Member, Me=Site Owner) and second film is about your regional settings. That includes keyboard and (!) currency settings. Maybe your Tenant was set only for English settings (reset after update?). Occasionally I have that issue, when I initialize a new Flow with Power Automate and currency Fields, then the flow settings are reset to english. Are you working with Power Automate Flows? That could be a reason.
Please make sure your Account Settings (including the Office Apps!) are in Spanish. If you cannot change these settings, pls. write a ticket to your Teams Admin.- MartaGMOct 22, 2021Copper Contributor
Hi Eva Vogel !!
We are almost there, but not yet.
You are completely ritght about using power automate, I use it for creating the elements in those lists. And I also think the problem is in the language, but I can't find where to correct it.
I mean, I asked my colleague to send me a picture of the list he can see on his computer and compare it to mine, and guess what? the dates are different:
Here's what he sees:
and here, what I see:
Mine is a mix between Spanish and English!!
So I checked what you told me, and changed to Spanish the same option you changed to German, but nothing happend 😞
Any idea how to continue?
Thanks in advance for your help.
Regards, Marta
- Eva VogelOct 22, 2021Steel Contributor
MartaGM the "user-friendly" format in Date/Time Columns can be changed into a user-understandable format. Pls. see my new "greatest hits" Date & Number Formatting blockbuster 🙂 if you want to review the settings on your flows and in happy end you will also see, that "user-friendly" does not correspond in a weird way with that new Date Control. Maybe this is the cause of your column trouble...
Next idea: the regional settings could have something to do with the Tenant Settings. If your company changed the subscribing options, maybe they pay less but now the tenant is located to another country (?)...
Another idea: If that Version Field in your list only accepts a Number, which deals with "." usually, but the "." is converted to a "," (Comma), it is a clear sign, that your list changed the regional settings for you. I know, this sucks. Pls. try inserting a Version "Number" with Commas instead of Dots.
Have a good day
- Eva VogelOct 21, 2021Steel Contributor
MartaGM this little tutorial is the stuff about checking your own permission level in a sharepoint site. If it is a standard level "Member" (Mitglied) or "Owner"(Besitzer) you should be able to edit all items in that list. If not, maybe your Owner knows why (this is the user level to control the Members and their access)... 😉