By -

Add or Update Rows in Excel from SharePoint with Microsoft Flow


Comments

Post a Comment

Popular posts from this blog

SPFx with PnPJS CRUD Operations (V3)

By -
Image
Create new SPFx React webpart         Follow this post to create new SPFx solution & open it in VS Code.           Note: All file creation & Basic details of each files are available in this post. Final Output:      Here we will be getting all the SP list names into dropdown list & doing CRUD operations in the selected list. Install PnPJS:       Run this below command to install PnPJS. (Note: Here we use PnPJS Version 3, sp & graph objects have been deprecated. We will be using spfi         npm install @pnp/logging @pnp/common @pnp/odata @pnp/sp --save Create "pnpjsConfig.ts":                In PnPJS Version 3 sp  and  graph  objects have been deprecated and will need to be replaced ( link ). So we are using this new config file. (RightClick on webpart folder>newFile>pnpjsConfig.ts) webpart.ts: Initial...
Read more

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

A type named 'SP.Data. could not be resolved by the model error

By -
Image
When we are trying to update task list we will get this error " A type named 'SP.Data. could not be resolved by the model error. When a model is available, each type name must resolve to a valid name must resolve to a a valid type" This happens because there is a space in the list name. To resolve this issue we need to get the exact list name to be used in "SP.Data" 1.Use the below URL in chrome browser <SiteUrl>/_api/web/lists/GetByTitle('List Name')/ For Example:  https://SiteURL/_api/web/lists/GetByTitle('Workflow Tasks')/ Some times in Chrome browser you may get Authentication error. For that first open the list from your Chrome browser & then use the above URL. 2.Find "SP.Data" -> now you will get the list name that you can be used in SP.Data.ListNameListitem
Read more