💻 Want to confidently navigate SharePoint and Microsoft 365? Enroll in my revamped On-Demand SharePoint and Microsoft 365 Academy 👉 academy.sharepointmaven.com/
Thanks for the video! I have a form in which I have 16 different choice columns and I'm trying to add a validation or something to send and error if the user selects the same answer within those 16 selections. Do you know how can I do this? Thank you very much!
Hi, thanks for the great videos about Share point! Very helpful for me. Do you know how to delete a column on site pages? I created a column "comments" with some validation, that I would like to delete it but I cannot see how to do it. Thanks in advance for your guidance.
Happy to hear you find my videos helpful. You would delete column on site pages library same way you would delete it on any other list or library - you need to navigate to Gear Icon > Site Contents > Site Pages Library
Thanks a lot for this tutorial, very illustrative. A question: Is it possible to do a colum validation using information that is on another list? Let me explain it further using an example: Let's say I have a list for recording inventory items, there must not be duplicated values, but the database of the inventory is in another list. Is it possible that when the user tries to add a new item, the validation checks first if that value is already there in the other list ?
Loved the presentation. Is there a way to do Column validation against a text file. For example the column is "mailbox" and I can upload all the mailboxes in a text file to SharePoint. I could have created a LIST as well, which I tried doing, although we have over 45000 mailboxes and the QUERY only shows 5000. That is why I am looking for an alternate way to Validate the field.
I have noticed something when working with an uploaded file. 1. In Column Validation - If I enter an incorrect date, the validation message is hidden behind the date picker, but it will not save until corrected.
Hi. Thx for sharing most precious knowledge... I would like to hide the attachment but not the metadata in the library.. can this be achieved by column validation .. Thank you in advance
Hi, thanks for the video. It was very useful. Is there any way to do a list validation using the column modified by or created by? I'm developing an approval flow using powerautomate and when I block editing list by the user using an StatusID column (simple validation like "StatusID = 1"), I also block editing list by the flow. How can I solve this?
Note that column level validation does not work on folders in a library, it only works on documents in a library. It appears the folder view shows the column, but it's value is not saved as a property on the folder. In essence, folders are saved differently than documents. To have validation work on folders, you must put the validation for a "new" record in the library settings.
How could you validate a column for a canadian postal code? so first charcter is a letter, second is a digit, then third is a letter and so on for 6 characters. The final format is A1A1A1. Thanks.
I have one question,If someone is coming to the SharePoint list and that time they want a pop up message that please put this type of data,how to do so?What will be the function?If you can help.
💻 Want to confidently navigate SharePoint and Microsoft 365? Enroll in my revamped On-Demand SharePoint and Microsoft 365 Academy 👉 academy.sharepointmaven.com/
Thanks for the video! I have a form in which I have 16 different choice columns and I'm trying to add a validation or something to send and error if the user selects the same answer within those 16 selections. Do you know how can I do this? Thank you very much!
I am not aware of an easy solution to this
Hi, thanks for the great videos about Share point! Very helpful for me. Do you know how to delete a column on site pages? I created a column "comments" with some validation, that I would like to delete it but I cannot see how to do it. Thanks in advance for your guidance.
Happy to hear you find my videos helpful. You would delete column on site pages library same way you would delete it on any other list or library - you need to navigate to Gear Icon > Site Contents > Site Pages Library
Thanks a lot for this tutorial, very illustrative. A question: Is it possible to do a colum validation using information that is on another list? Let me explain it further using an example:
Let's say I have a list for recording inventory items, there must not be duplicated values, but the database of the inventory is in another list. Is it possible that when the user tries to add a new item, the validation checks first if that value is already there in the other list ?
Juan, this is not possible using out of the box functionality. You will need to use Power Apps for this.
Loved the presentation. Is there a way to do Column validation against a text file. For example the column is "mailbox" and I can upload all the mailboxes in a text file to SharePoint. I could have created a LIST as well, which I tried doing, although we have over 45000 mailboxes and the QUERY only shows 5000. That is why I am looking for an alternate way to Validate the field.
No, this is not possible
I have noticed something when working with an uploaded file.
1. In Column Validation - If I enter an incorrect date, the validation message is hidden behind the date picker, but it will not save until corrected.
I think I noticed that too - it is a bug!
@@SharePointMaven So it wasn't just me then - very frustrating. Thank you Greg
Hi. Thx for sharing most precious knowledge... I would like to hide the attachment but not the metadata in the library.. can this be achieved by column validation ..
Thank you in advance
No, not possible via this functionality. You can disable attachment via library advanced settings
Hi, thanks for the video. It was very useful. Is there any way to do a list validation using the column modified by or created by? I'm developing an approval flow using powerautomate and when I block editing list by the user using an StatusID column (simple validation like "StatusID = 1"), I also block editing list by the flow. How can I solve this?
I honestly do not know how to solve this, I am not a Power Automate expert
@@SharePointMaven Ok, no worry. Thanks anyway
thank you for this video can i please ask how do i prevent users to select certain dates with validation ?
I am not aware of a way to do so
Note that column level validation does not work on folders in a library, it only works on documents in a library. It appears the folder view shows the column, but it's value is not saved as a property on the folder. In essence, folders are saved differently than documents. To have validation work on folders, you must put the validation for a "new" record in the library settings.
Correct, this is by design
How could you validate a column for a canadian postal code? so first charcter is a letter, second is a digit, then third is a letter and so on for 6 characters. The final format is A1A1A1. Thanks.
I suggest you pose this question to Excel pros - not sure if possible to do so with formula
Does anyone know how to convert xml data in a column into separate columns?
Not aware of this
I have one question,If someone is coming to the SharePoint list and that time they want a pop up message that please put this type of data,how to do so?What will be the function?If you can help.
Not possible in SharePoint out of the box