Skip to main content

Posts

Showing posts from March, 2020

How to find out Current Usage per user in One-drive using Powershell

Run the below power shell commands , it will give you the storage information and set storage quota. Get current usage per user in Onedrive Get-SPOSite  -IncludePersonalSite $true -Limit all  -Filter "url - like '-my-sharepoint.com/personal/'" | Select url, StorageUsageCurrent | Sort-Object StorageUsageCurrent  -Descending | Format-Table -wrap -Autosize Set Onedrive storage limit to 1TB (1024 GB) using powershell  Set-SPOTenant - OneDriveStorageQuira 1048576 Set Onedrive storage quota for specific user Set-SPOSite -Identity https://healthtest-my.sharepoint.com/personal/venkat_healthtest_onmicrosoft_com -StorageQuota 1024 Reset storage quota for specific user Set-SPOSite -Identity https://healthtest-my.sharepoint.com/personal/venkat_healthtest_onmicrosoft_com -StorageQuotaReset

How to export SharePoint list data to Excel using Flow(Power automate)

Daily export the SharePoint list items to excel format, send an email. Step 1 :Create SharePoint List and add items. What Is A SharePoint List? A SharePoint list is similar to an Excel Table, it’s a container for data. SharePoint lists allow you to store data in list format with rows and columns. From the homepage of your SharePoint site, press the New button then choose List from the options. Give the list a name(CLF Data) and description and press the Create button. Step 2 : Go to flow  https://flow.microsoft.com/  and use your credentials to create a flow. Step 3 : Use " Recurrence " action to run flow on specific time for daily/weekly/monthly. Step 4 : Create a excel file in your desktop and insert table ,add columns then upload to SharePoint Document Library. Step 5 : Add " List rows present in a table " action in flow to identify your table. Step 6 : Insert " Apply to each " control to delete existing rec...