Posts

SharePoint App Only Registration Key Renewal script

################################## ## Checking secret working ################################## $clientSecret = 'xxxxx' Connect-PnPOnline -Url "https://xxxx.sharepoint.com/sites/DevSite" -ClientId 67c86709-5348-45b9-a16b-9b7a983a20c2 -ClientSecret $clientSecret Get-PnPConnection Get-PnPListItem -List LookupList ################################### ## Get all Keys #################################### $msolcred = get-credential connect-msolservice -credential $msolcred $clientId = "67c86709-5348-45b9-a16b-9b7a983a20c2" $keys = Get-MsolServicePrincipalCredential -AppPrincipalId $clientId $keys ################################## ## Remove keys ################################## Remove-MsolServicePrincipalCredential -KeyIds $keys.KeyId -AppPrincipalId $clientId ######################################## ## Generate key for 3 years ######################################## $bytes = New-Object Byte[] 32 $rand = [System.Security.Cryptography.RandomNumberGenerator]::Cre
Post a Comment
Read more

Microsoft Forms File Upload & limitations

Image
File upload controller File upload controller can be added to the form just licking the type of the file. Once form is submitted file is uploaded in to the OneDrive as follows. File can be access using Power Automate and can be saved in to a SharePoint list. Limitations Forms file upload is available only who login. If you want to have anonymous access to the form this can not be achieved. Power App Portal is another approach to if you are dealing with anonymous users who want to upload files.   https://powerapps.microsoft.com/en-us/portals/
Post a Comment
Read more

Microsoft Flow SharePoint isFolder condition check

Image
When you want to check a condition for value coming from json boolean type use the following technique. I spend quite few minute  for couple of time to get a proper way. Thought of recording for future use.
Post a Comment
Read more

SharePoint Online remove App menu item missing

Image
I deployed some test apps to check some functionality and suddenly noticed that remove app menu item is missing. Wasting about an hour figure out that we need to click on the return to classic SharePoint to go back to older view and use that menu to remove the app. Missing Remove menu item. Old look and feel with remove menu item Just after doing that faced another issue where I couldn't go back to the new look and feel mode. I had global admin privileges when I was doing this so I initially though i change entire tenant back to classic mode. Killing another few minutes figure out its just a temporary and once you close all the browser windows and login again it will give you the modern look and feel. Hope this will save time on someone else.
Post a Comment
Read more

SharePoint 2013 Quick edit for large lists

Image
In SharePoint 2013 if list has large no of items sometimes its not showing quick edit option for the list. When this happens there is another way we can edit all the rows by using DataSheet View. https://spdatasheet.codeplex.com/
Post a Comment
Read more

How to get SharePoint dll version using JavaScript quickly

If you are working on SharePoint apps development you will need to know the SharePoint dll version to put webparts in to the page. In webparts we need to provide the SharePoint dll version in the  '  In this sinario you can use following service url and make a quick call and get the version of the SharePoint dll on Office 365 SharePoint Online as well as SharePoint Onprem. /_vti_pvt/buildversion.cnf SharePoint On Premise output vti_encoding:SR|utf8-nl vti_buildversion:SR|15.0.4737.1000 SharePoint Online Office 365 output as of 04/07/2017 vti_encoding:SR|utf8-nl vti_buildversion:SR|16.0.6621.1204 Function for get the version no.     getSharePointVersion: function () {         var ver = null;         $.ajax({             url: "/_vti_pvt/buildversion.cnf",             async: false,         }).done(function (result) {             var lines = result.trim().split('\n');             if (lines.length == 2) {                 var versionProperty = li
Post a Comment
Read more

Create SharePoint online site collection using console application

This summary is not available. Please click here to view the post.
Post a Comment
Read more