Posts

Showing posts from August, 2022

PowerApps Introduction & Cascading Dropdown using PowerApps

Image
 PowerApps Introduction:     Power Apps is a service that lets you build business apps with no coding experience required. Using Power Apps web part it can be added to page by the app’s web address or the app ID. Power Apps also provides an extensible platform that lets pro developers programmatically interact with data. Cascading Dropdown using PowerApps     In this example we will see how to create cascading dropdown using PowerApps. We have 2 dropdowns(Country & City). Based on Country dropdown city will be loaded. SP List setup: we have 3 lists. Country - Contains Country Names City    - Contains Country & Releva nt City Names (Country is lookup from Country List) EmployeeDetails     - Contains EmployeeName, Country & City (Lookup from City List) Open PowerApps Studio: Here in Employee details new form -> Any country selected City dropdown will show all city names irrelevant to the country. Using PowerApps we will show City relevant to country selected. List Setting

Copy Files from one SharePoint library to another using Power Automate

Image
     In this post we will see how to copy files, when we upload files to one SharePoint library it will be automatically copied to another SP library using Power Automate. Scenario 1 : Copy File To Same Level (Files will be copied library to another library & not subfolder level) Scenario 2 : Copy File To Different Level dynamically(Files will be copied library sub folder to another library any subfolder) Scenario 1: Copy File To Same Level "SP Library -> SP Library"      Copy File To Same Level. Files will be copied library to another library without subfolder levels.(Below is image is the complete code for scenario 1) Create: From your Power Automate site > Create > Automated Cloud Flow > Enter Flow Name > Select trigger "When a file is created in a folder SharePoint" > Click Create Enter SourceFile Details: Select trigger options of which "Site Address" & Library name > Click New Step > Search "SharePoint" >

Invoke One Flow From Another Flow (Call Child Flow from Parent Flow)

Image
    In this example we will be creating SharePoint List items by child Flow and Parent Flow. Here we will call Child flow from Parent flow & both will create new items in List. Create Child Flow:               Child flow will be triggered "when HTTP Request received" & it will create new SP list item.   To Create Flow >  From "SharePoint admin center" > Power Automate Power Automate site > Create > Instant Flow Enter Flow Name & choose how to trigger the workflow "when HTTP Request received", click Create. Click on the header & click on payload to generate schema  Enter  { "Title" :""} & it will generate schema like below. then click "New Step" In new step > Search "SharePoint"  > Select "Create Item" > select SP URL & List name For the Title field when we click it will suggest to add Title from Parent flow(which we created in 1st step & Note: This title valu

Power Automate Introduction & Sample Flow to Create SharePoint List Item

Image
Power Automate Introduction:    Power Automate is  a cloud-based service that allows users to create workflows themselves.  Microsoft Flow is now called as Power Automate Example (Create SharePoint List Item):     Here we will create one simple flow which will create SharePoint list item. 1. Create Flow:             From "SharePoint admin center" > Power Automate Power Automate site > Create > Instant Cloud Flow > Enter Flow Name > Select Manually trigger a flow > Click Create Next page click "New Step" >in Operation enter "SharePoint' >In Action select "Create item" In this Create Item Action select Site URL > Select List Name > Enter Title value of new item > click Save. Now we have successfully created our Flow. next we need to run this flow Run Flow:  Click On "My Flows"> Click "Run" button of our Flow > Click Continue & Run > Now we can see the items created in the SharePoint l

Power Platform All Posts

Power Automate(MS Flow) Power Automate Introduction & Sample Flow to Create SharePoint List Item Invoke One Flow From Another Flow (Call Child Flow from Parent Flow) Copy Files from one SharePoint library to another using Power Automate Document Retention & Archival using Power Automate Document Retention & Archival With Email & Logging PowerApps Power App Types PowerApps Introduction & Cascading Dropdown using PowerApps Helpdesk App using Power App PowerApps Delegation For more details refer this YouTube  link

CRUD Operations using SPFx React Webpart & Rest API (SPHttpClient)

Image
      We will be covering below topics in this post. Office UI Fabric React(Fluent UI) Intro Create new SPFx React webpart Setup basic code structure  Setup SP Workbench(To test webpart): Deploy sppkg to App catalog Step 1: Read Operation: (Show all SharePoint list names to dropdown): Step 2: Create Operation: (Create new item to SharePoint list using button click): Step 3: Delete Operation: (Delete list item by button click): Step 4: Update Operation: (Update list item by button click): Code for CRUD Operations: Final Output:                We will be using "Office UI Fabric React" as a front end which is a official front end framework for office 365. If you are first time working SPFx React webpart then please go through this SPFx React Basic concepts Office UI Fabric React Intro:  Its a official front end framework for office 365  It provides various controls like buttons, labels, dropdowns, document card, etc  Installation comment:    npm install office-ui-fabric-react UI