By -

Add or Update Rows in Excel from SharePoint with Microsoft Flow


Comments

Post a Comment

Popular posts from this blog

Helpdesk App using Power App

By -
Image
Here we will create a simple helpdesk app with Admin & user login. Sample  Admin Screen: (Percentage Complete & Task Status Fields enabled for admin in edit screen) Sample  User Screen: In this post we will learn about: Connect to SharePoint DataSource (we have more than 200 connectors) Office365users - Connector(Give details about current logedin User, Office365users.MyProfile().Mail) Screen - Create Screen with different templates(Blank,Scrollable, Success,Form, etc) Controls - (Image, Rectangle, Button, Lable, Icons(BackArrow,Circle,Plus,Trash)) Gallery -Control to Read Item from SharePoint(like GridView) Grouping Controls - Group multiple Controls as single control Forms - PowerApp provides forms to Edit/Display SPList item(we can change Default mode to New/Edit/View)           Events : Set (GlobalVariableName, ValueToAssign) - create new global variable Navigate (ScreenNameToNavigage,ScreenTransition.None) - Move between screens Submi...
Read more

Add content type to SharePoint List/Library using REST API

By -
Add content type to SharePoint List/Library using REST API Use this below code to add content type to SharePoint Library using REST API. For this you need to use the content type ID. Below function will get the content type ID from content type name & we will pass the content type id to next function which will update content type to list/library. var   varContentTypeName = " Your Content Type name "; var   Listname = " Your List name where you want to add content type "; //This will get the content type ID from content type Name function  getContentTypeID() { var deferred = $.Deferred();     var  isCurrentUserIsApprover = false ; var  serverURL = _spPageContextInfo.webAbsoluteUrl; var  listURL = String.format(" {0}/_api/web/AvailableContentTypes?$select=Name,Id,StringId&$filter=Name eq '"+varContentTypeName+"' ",serverURL); $.ajax({ url: listURL, type: " GET ", async: false, headers:...
Read more

SPFx Run with elevated privileges

By -
Image
In this post we will create SharePoint list item using elevated access from SPFx webpart (by calling power automate post URL) Steps Involved: Register our add-in in SPO with full control permission Create Power Automate: It will create SP List item with above registered add-in Call Power Automate from SPFx webpart  In this post we will learn about: /layouts/15/appregnew.aspx  - Page to create Client Id & Client Secret /_layouts/15/appinv.aspx  - Page to give permissions to Client Id & Client Secret App Permission Request  xml   - where we mention scope & permission level of app permission Get Access Token   - Using client id & client secret from automate we will call http to get this Tenant ID   - Site settings>Site collection app permissions(tenant id will be available after @) httpClient.post()  - used to call power automate post URL from spfx (sphttpclient.post() -used in rest api calls) Access T...
Read more