Forum Discussion
Blank fields when editing an existing list element
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
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.
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
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
Hi again, I'm already desesperated 😞
I can't find the error.I could make the column to display the date just in Spanish (not mix with English) by changing the regional options of my computer, but I see the same whether I choose friendly mode or standard in the list setting. I thought it was supposed to display something different... furthermore, my column is set to date & time format, it force me to add time when I change the value but then it doesn't appear on the list:
- Hi Marta, some power automate ideas for you:
if you are the creator of that List Flow or a Co-Creator / co-Owner, you can add an action to convert field contents, not fields. This goes: a) create a variable with number in it, initalize the variable with your SP Lists Field. then choose a new action called "Number formatting" (Zahlformatierung) and choose the variable to convert the field content into a certain currency.
Or: Maybe the creator of that list did not select you as a User?
If possible it is easier for me to help, as you give me a screenshot of that flow...
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)... 😉
