SharePoint & Power Apps Learning

 https://www.matthewdevaney.com/the-complete-power-platform-pipelines-alm-setup-guide/ https://www.matthewdevaney.com/the-complete-power-platform-pipelines-alm-setup-guide/create-power-platform-environments-for-dev-test-prod/ Create an Environement from PP admin center For Dev env add suffix xyz(Dev) for understanding purpose choose type as Sandbox for development env add dataverse to store data(Yes) Setup for Test and Prod as well. Make sure enable it as managed environment. Test and production environments are known as target environments. All target environments are required to be  managed environments  to use Power Platform Pipelines. Test env type should be sandbox Prod env type should be production ----------------------------- https://www.matthewdevaney.com/the-complete-power-platform-pipelines-alm-setup-guide/install-power-platform-pipelines-in-the-host-environment/ Install Power Platform Pipelines In The Host Environment The  Power Platform Pipelines  a...

Power Pages deployment process: 1st method - We can do import and export to Dev-Test-Prod env. 2nd method - Native power platform pilelines 3rd method - Powershell. Now we learn about Navtive Power platform pipeline. prerequisites:  Go to solution, Start creating new solution. (Test22)  We need to add power pages site to our new solution "Test22" under Objects tab. Solution is one thing that is supporting the ALM in powerapps. Add existing Site->PowerPages sites will show->Select site It will add webfiles, html, javascript all the files or objects related to it Click on Site on left navigation->3 dots->add required objects. It will add all the dependecies. Manual deployment->Export solution and publish->export as managed solution for testing->Production. Now how to do with pipeline process. Enterprise level it is popular method with pros and cons. Choose route of power platform pipeline method from left navigation. It is fast but it needs managed environm...

 More than 365 plus connectors avaialble as microsoft and non microsoft services you may want to communicate with services that are not available as pre buit connectors. Capability to create, share the connector, trigger the connectors on it own, or by any actions. Life cycle: Build your API: using RESTAPI(Like power apps we have Logic apps, which supports SOAP APIs) that allows logic apps, power automate, powerapps to communicate with rest or soap api. two types of APIs: public apis(public internet eg: spootify, slack, rackspace etc..) private apis (visible only to your network) For public apis that you can plan to create or manage using these microsoft azure products Azure functions, Azure web apps, Azure api apps. 2. Secure you api: We have standard authentication methods for you apis and connectors with help of azure active directory. 1. Generic OAuth 2.0, 2. OAuth 2.0 for specific services Azure AD, Dropbox, Github, Salesforce. 3. API Key 4. Basic authentication (username and ...

Environment: System Admin, Environment Maker. We can add users to the environment. ----------------------------- DataVerse: role based security access, rich metada, logics and validation: calculated columns, business rules, workflows, bpflows,  ------------------------------- Modeling the business data, define the business process, compose the app -------------------------------- Tables: D365 sales,services,marketing use dataverse to store and secure data. Prefer standard tables for good practice. Table relationships:  1:N as many related table rows are associated with single primary table row in a parent/child relationship. N:N as many table rows are associated with many other table rows.  Type of table owners: user or team owned & organization owned. user or team owned: actions that are performed under the rows are controlled at user level. organization owned: access to the data is controlled at the organization level. Activity table: Calendar entry table is called ...

ShareGate: SharePoint migration: Copy (navigation) copy structure and content copy content source and destination provide authentication as current user or other user. For other user(provide login credentials) Click on run pre check. We have sub options to copy lists/libraries alone,content type alone, site columns, permisson groups, workflows, manage metadata. For example copy list or lists, click on List, select the source list or multiple list. On top right corner - Options click on it. Options: General: Action to perform: copy as subsite of "parent site name" or  merge with 'parent site name' it self. Configrations: check mark options default selected. But we can add more. Permissions, List views, webparts, Required features customize list forms( eg: Nintex forms). Workflows (Nintex or Designer or out of the box) List content Limit to (5) latest versions( which is max versions to copy) site navigation, subsites, Required features, Modern experience (All lists will...

CSOM  CSOM allows users to access SharePoint site which are hosted outside with out using webservices like REST APIs. We have 2 options in SP. 1. .Net C# CSOM 2. JSOM CSOM happens behind. Converts API call in to XML and send to the server. Server receives the request and make appropriate calls Server gives back the data to SharePoint in the format of JSON Step 1: Create the context Step 2: Use load/loadquery to specify what data we wish to get Step 3: ExecuteQuery/ ExecuteQueryAsync Sending the request to the server Here API request sending to the server in the format of XML Step 4: Make changes to the data Step 5: Save the data using ExecuteQuery/ExecuteQueryAsyn  Here data received from the server in the format of JSON If we create sharepoint solution in VS 2012, default using Microsoft.SharePoint.Client Otherwise, for general C# code we need to add the dll and specify in .cs fil...