Export / Import from Excel file in SharePoint (SPFx)
Here is the tool which will help you to import excel file into a list. This tool will not create any kind of list or column. It will help users to import their excel file in specific list. This tool also allows users to update existing records directly from excel file. I have develop the tool in SharePoint Framework. Currently this tool is for SharePoint Online version only. We are supporting following columns : Single line of text Multiple lines of text Number Yes/No Person or Group (Person + Group) Person or Group (Person + Group) (Allow multiple selections) Date and Time Choice Choice (Allow multiple selections) Hyperlink or Picture Currency Managed Metadata Managed Metadata (Allow multiple values) Lookup Lookup (Allow multiple values) Installation of App :- 1. Click here to download the sps-import-from-excel.sppkg. 2. Visit the Microsoft 365 SharePoint Admin Center 3. Go to Apps -> App Catalog. If you don't have app catalog, here are the instructions for creating one. If you have Site Collection level App Catalog, just to to Apps for SharePoint from your site collection. 4. Click 'Upload' and select sps-import-from-excel.sppkg file to upload. 5. Check the box for Make this solution available to all sites in the organization and click the Deploy button. 6. A successful installation will look like this: 7. if you receive an App Package Error Message stating, "Deployment failed," as shown here, simply delete the .sppkg file and repeat steps 4 and 5 to redeploy. 8. Now go to the site where you want this tool. Just create a new page or edit existing page and add a webpart 'SPS Import From Excel'. This tool has help on each steps. You can read and start exporting or importing the excel. How To Setup How To Use Enjoy!!!
where to add PnPTelemetry code in SPFX PnP solution
Hi all, I need to include PnP Telemetry in my code. I am working on SPFX React based solution. I haven't used it before. Can you guide me where to use below lines of code, in Constructor or render method? const telemetry = PnPTelemetry.getInstance(); telemetry.optOut(); This is one of app deployment requirement, haven't found much documentation about it. Will apricate your help on this.Include X-ClientTag header
I am working on react based SPFX solution and using PnP module for retrieving list data. IT Deployment teams asked me to must include X-ClientTag header on SharePoint client side calls. I am using below line of code for retrieving date. import { sp } from "@pnp/sp"; sp.web.lists.getById(<list id>).items.get(); //sample line Let me know if we can add X-ClientTag header with above code?Deploy SPFx production solution files in specific folder with in container on Azure CDN
When we creates SPFx solution and deploying the build files on Azure CDN, it deploys all the files in a container which you mentioned in "deploy-azure-storage.json" file. This is bit messy to see. Because you can deploy multiple solution on the same container. But what if you want to manage solutions by Solutions or By versions. Here is the way. I will show you how to deploy SPFx production deployment files in a specific folder in the Container on Azure CDN. First you have to deploy some gulp task packages in dev-dependencies npm install gulp-util gulp-deploy-azure-cdn --save-dev Now you need to make following changes in the "gulpfile.js" file : const deployCdn = require('gulp-deploy-azure-cdn'); const gutil = require('gulp-util'); gulp.task('deploy-azure-storage-folder', function () { return gulp.src('temp/deploy/**/*', {}).pipe(deployCdn({ containerName: '<<Your Container Name>>', // Container created in StorageAccount serviceOptions: ['<<blobstoragename>>', '<<MyLongSecretStringFromAzureConfigPanel>>'], // custom arguments to azure BlobService folder: '<<Folder Name To Store>>', // path within container deleteExistingBlobs: false, // true means recursively deleting anything under folder concurrentUploadThreads: 20, // number of concurrent uploads, choose best for your network condition metadata: { cacheControl: 'public, max-age=1', // cache in browser cacheControlHeader: 'public, max-age=1' // cache in azure CDN. }, testRun: false // test run - means no blobs will be actually deleted or uploaded, see log messages for details })).on('error', gutil.log); }); At last just call the gulp task "deploy-azure-storage-folder" with command gulp deploy-azure-storage-folder. So gulp command sequence should be like : gulp clean gulp bundle --ship gulp deploy-azure-storage-folder gulp package-solution --ship
