SharePoint List JSON, IF Blank Field Formatting
Hello and thank you very much in advance for your valuable insight. I need to format column [REQUEST FORM] with these conditions: IF column [REQUEST] is not blank then display "REQUEST FORM" with clickable link to form otherwise leave blank I have everything working except for the IF portion. Will you please help me with the JSON formatting? Here is the JSON: Here is the result: Thank you again for your help.
How can I recover a corrupted Sharepoint list?
The user tried to delete a column and suddenly received this error: However, trying to navigate back to the list, the page only shows the title. No columns, no "Add item", no Settings "gear" icon, no Recycle Bin. Is there some way we can retrieve the list? There is no data in the list, it is just the configuration (lookups and rules, etc.) that we need to get back.
How to set time limit for a SharePoint Calendar?
Hi, I have created an event calendar and I want if a user creates a event he/she have option to choose event start and end date with time. This feature is already OOTT but I want to set that end time won't exceed 4 hours from start time. For eg. If start time is 7th feb 2021 10:00AM selected and the end time is 7th feb 2021 03:00 PM selected then it will show that user an error "End time shouldn't exceed 4 hours from Start Time." Is there any JavaScript code available to help solving this issue or any List Validation formula?? Please help.
SharePoint Columns - ID Records from Different List
I have two separate lists, with one recording active items to be updated and worked, and the other list is intended to collect data as an artifact/intake form. However, with limitations of Power Automate and the data sensitivity involved, I only have the option to create a SharePoint MS List to collect data from the user and populate the data manually in the active item list. Is there any way I can create a column in SharePoint that exports the values in the Intake list based on the active item IDs (i.e., date, numeric value) dynamically, so that users can only choose drop-down options that exist? I have ideas for data validation before the final record is updated, but it would be much easier if users had the option to see those values. Otherwise, it appears I would need to update the choices/options for the columns. Please let me know if I can clarify my question at all. I am still pretty new to SharePoint, so any help or suggestions is greatly appreciated. Thank you in advance!Anyway to give customize view permission without manage lists?
In my org, we provide Sharepoint Online sites to users "as-is", for a specific use case and the "manage lists" permission is a no-no. But we would still like to allow them to customize existing list views. e.g. show/hide columns and set column order and width. Is there any way to have one without the other?
Issues Moving a SharePoint List with "Person or Group" columns to another site
Hello everyone, I am facing a problem while trying to move a SharePoint list from one site to another. The list has approximately 45,000 records and contains "Person or Group" columns with users who no longer work at the company. This prevents me from moving the list entirely because: I cannot save the template with the included content: It only allows me to save the template without the content. Error when transferring information with Power Automate: When I try to transfer the information, it fails because "Person or Group" columns only allow inserting existing users. I do not have access to tools like Sharega-t-e, and although I know it can be moved with PowerShell, I am unsure of the necessary permissions or how to do it correctly. Could someone suggest a solution or alternative method to move this list without losing data and without failing due to nonexistent users? Thanks in advance!Sharepoint news post to the correct Teams/Channel through Power Automate
Hello everyone, When news is posted in Sharepoint site it sends adaptive card with Power Automate to the right Team/Channel. I am using trigger: When a file is created then action: Post card in a chat or channel, where I can select the Post in Team and Channel. But it should send dynamically in the right Team/Channel how can I trigger this from the Sharepoint main Site and when a news item is posted how to get all the data like groupId Team, ChannelID so I can then apply dynamically for this specific Team and channel? Maybe using Sharepoint list to lookup and then for example use Switch/Else if to compose the metadata? Thanks hoping to get in the right direction if possible.Power App form locale settings?
I have a Power App form connected to a Sharepoint list on a subsite. I'm having issues with the default form showing that I've asked in a separate post. When the form does show, the regional display of the dates are incorrect. They should be English UK, but are showing as US. They're correct in Power Apps when 'playing' the form for preview. I've checked the regional settings and they are as they should be. Also, it ignores the padding I've set on the dates (date pickers) and combo box controls. While creating the form: While using the form in the Sharepoint List:
