{ “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", “elmType”: “div”, “txtContent”: “=replace(replace(replace([$FileRef],[$FileLeafRef],’’),’/sites/test/Shared Documents/’,’’),’/’,’’)” }

Your first 20 files have been processed. To apply autofill columns to more files, select the files you want to update and choose Autofill columns > Autofill. New and edited files are processed automatically. Create the following autofill columns Claim ID Policy number Claimant name Address (UK cities) Phone & email Claim type (motor, health, property, travel, accident) Incident date & location Claim description Claim amount (£) Report date Signature You can select all files up and click autofill to process the contents

emove user from the SharePoint Online site collection Go to the site Change the URL to have /_layouts/15/people.aspx?MembershipGroupId=0 at the end Find the person you want to remove and click the checkbox to select them Then click ‘Actions’ at the top Select ‘Delete user from site collection’ then Yes to the warning message. Then go back to the Owners / Contributors group that you need them to have access to and give access again.