Dynamic Mandatory Fields
In a SharePoint library, I have folders which are = a. Admin b. Events c. Furniture and Moves d. Janitorial and Maintenance e. Parking and Transportation f. Shipping and Receiving g. Supplies and Equipment h. Waste and Recycling I have Meta data across the library whose data type are all choices and are: a. Document Type = Contract, Financial, planning b. Building = Gym, Garage, Heating c. Asset Category = Office, Playground d. Fiscal Year = FY23, FY24, FY25, FY26, FY27 e. Vendor = Maple Leaf, Canadian Tire, Home Depot f. Status = Active, Pending, Not Active g. Retention Label = 3 years, 5 years h. Service Type = Admin, Events, Furniture and Moves, Janitorial and Maintenance, Parking and Transportation, Shipping and Receiving, Supplies and Equipment, Waste and Recycling Service Type and Retention Label are mandatory fields, with the Rule below for all the files in the various folders: IF Folder Name = Admin, then Service Type = Admin and Retention Label = 5 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Events, then Service Type = Events and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year, Building and Vendor IF Folder Name = Furniture and Moves, then Service Type = Furniture and Moves and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Building IF Folder Name = Janitorial and Maintenance, then Service Type = Janitorial and Maintenance and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Parking and Transportation, then Service Type = Parking and Transportation and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Shipping and Receiving, then Service Type = Shipping and Receiving and Retention Label = 3 years; the mandatory fields should be Document Type, Status IF Folder Name = Supplies and Equipment, then Service Type = Supplies and Equipment and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Waste and Recycling, then Service Type = Waste and Recycling and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Vendor I have used Column Default Value Settings for SharePoint to display Auto-Display the Service Type and Retention Label, but I cannot seem to perform the conditional mandatory fields using Validations setting for the other requirements. Please helpExternal Users Unable to Access Microsoft List Form
We have created a Microsoft List and are using the default Microsoft Lists Form for data entry / intake form. Internal users can access the form URL and submit items successfully. However, external users are unable to access the form link, even though they have been granted Contribute permissions to the SharePoint list. External users can: Access the list Create new items using the + New button Edit items based on their permissions However, they cannot access the dedicated Microsoft Lists Form URL and getting following error. This link is only available to internal users. This link is not available to you. Our requirement is to allow external users to: Open the Microsoft Lists Form URL View the form Submit new items without providing additional access beyond what is required for form submission, and without using Microsoft Forms. Is guest/external user access to the Microsoft Lists Form experience supported? If so, what configuration or permissions are required to enable external users to access and submit items through the form URL?
Can you preserve links when exporting from a list to Excel?
Hi! I have a list with a multiline text field set to support enchanced richtext used to store URLs of files. I am inserting data into this list when people submit a Jotform using Power Automate to connect the two. In Power Automate, I build the field value by looping the uploaded files and building out HTML: <a href="https://www.server.com/path/file.png">file.png</a><br> <a href="https://www.server.com/path/file.pdf">file.pdf</a><br> Problem is, if I go to the list and do Export to Excel, the query.iqy file I get just shows file.png and file.pdf as basic, nonlinked text in the column. Is there any way to get Sharepoint to create an Excel file where the links are preserved?Recycle Bin and Site Content Hidden for Site Members and Site Visitors
I posted this before but made a mistake with my write up, so I am reposting. I have a requirement that the Recycle bin and Site Contents should be be hidden from the Site Members and Site Visitors. Please how can I achieve this because the Server Infrastructure activation is not working for me. Any workarounds? Please helpHow do I get quick actions to show up in Gallery view for a list?
Hello, I'm creating a sharepoint list of employees. I create quick actions for sending an employee a teams message or an email, and they work fine in list view. However, in gallery view they don't show up. The field title is displayed, but there's nothing inside, which I've highlighted with a red box. Is it possible to get the quick action buttons to appear in this view?
List rules
Hi everyone, since the legacy list alerts have been retired and rules came in, users with read permissions are not able to create rules without leveraging the power automate service. in my opinion read inly users should be able to create alerts based on a separate role action. at the same time, alert related action are still active under permissions level options. is there anyone else trying to provide rule action to read only users and is so how did you proceed? Kind regards, George StylianouSharePoint List Accessibility Issues
I have team members that go around with iPads so that they can document issues at our sites within a Microsoft List. However recently there has been an issue where the save button just cant be reached anymore when using the web version. We tried using the SharePoint app, however that just results in the picture fields becoming read only, am i doing something wrong here? Is the only way to solve this through customized forms in Power Apps? Because that also just turns all my fields into custom data fields.
