Learning SharePoint

We have been working with PowerApps, PowerApps and Dataverse and now I thought of sharing a few tips to ease your work if you are new to PowerApps + Dataverse as a combination. I will be sharing a few more tips in my upcoming blogs but to get started, Let’s take Multi Choice Columns this time. Unlike SharePoint or any other data source, Dataverse Multi choice columns are different so basically, I cannot go to my PowerApp and directly print selected value in a label. So, this is how you can show multi choice values in label. You need to use concat that allows to concat multiple selection. PowerApps has concat function that takes. Concat function syntax :  Concat (  Table ,  Formula  ) In my case I am trying to render a multi choice column values into a vertical gallery webpart. I have added a label control to a vertical gallery and then added below code.   Concat(ThisItem.ColumnName,Value & "") Hope this helps, Thanks, Keyur

We have been working with PowerApps, Power Automate and Dataverse and now I thought of sharing a few tips to ease your work if you are new to Power Automate + Dataverse as a combination. I will be sharing a few more tips in my upcoming blogs but to get started, Let’s take Lookup Columns this time. Unlike SharePoint or any other data source, Dataverse Lookup columns are different so basically, I cannot go to my Power Automate and directly update a lookup field with just the ID. You will keep on getting error and flow will keep on failing. So, this is how you can update lookup columns. We need to provide Dataverse table name and GUID in parentheses. Contacts(83c259e2-1039-4110-af70-79f353dc92a5)   This will handle lookup. In you add new item/update action we put the source table name with GUID of lookup. Regards, Keyur Pandya

Since a few months I am working for a client who is trying to do miracles using Power Platform. I am fortunate enough that he picked me as a developer lead for this project. We have been working with PowerApps, Power Automate and Dataverse and now I thought of sharing a few tips to ease your work if you are new to Power Automate + Dataverse as a combination. I will be sharing a few more tips in my upcoming blogs but to get started, Lets take choices columns. Unlike SharePoint or any other data source, Dataverse choices are different so basically I cannot go to my powerapp and check Department = "SharePoint" in dataverse. You will keep on getting error. Dataverse assigns a ID to each choice that we add to a dataverse column. Something like below. How do I know what is the ID of my choice? You need to go to the table that you are using in Dataverse, click on column. From panel on right select "Edit Choices" and then Click on Eclipses besides choice and click on "

T his week we would be looking into our first web UI flow demo on how to create UI flows using Power Automate Desktop. Just in case if you are not aware about UI Flows/ Power automate desktop flows. Please refer my previous blogs. Introduction to UI Flows UI Flow Triggers Creating first UI Flow To create a web UI flow you will have to download Power Automate addin for the browser you are using. Note: Supported browsers Chrome, Firefox, Microsoft Edge, Internet Explorer. Today we will create UI flow for web, Our case study today will be simple. We will launch browser and record actions that we perform. Open Power automate desktop app. Click on New Flow First action to be dragged will be Launch Chrome.       Click on Save. Not click on web recorder from top left corner and click on web recorder.   You should now see a popup, select Chrome from there. Open the URL you added in Launch chrome action. Click on start recording button from recorder screen. Perform actions you want to and then

This week we would be looking into our first demo on how to create UI flows using Power Automate Desktop. Just in case if you are not aware about UI Flows/ Power automate desktop flows. Please refer my previous blogs. Introduction to UI Flows UI Flow Triggers Today we will be creating UI flow that will create an excel file add a few email addresses to it and than send email to respective emails. What you need to get started, Power Automate Desktop installed in your machine. You can download it form here . Click on New flow from top right corner of the Power Automate Desktop screen.  Now search form Launch Excel action from Actions panel. Drag action to main section. double click on it to open action config section. Similarly drag  Create New List. Drag Add item to list and double click it to add email addresses. Note: You can add more email address to same list that we created earlier. Now drag Write to Excel worksheet and double clock on it to configure properties. Now drag Save Ex

I n continuation to my previous blog post today we will see what are different options to trigger a UI flow. Deciding the nature of triggers may depend on the nature of the flow(UI Flow) that you created. Attended Mode: To run an attended UI flow, you need to have an active Windows user session that matches the name of the user configured for your connection. The session must not be locked. Unattended Mode: To run unattended UI flows, the target machine needs to be available with all users signed out. Prerequisites You need the  on-premises data gateway  for your device to have the UI flow triggered by Power Automate. A work or school account. You can run UI flow from Power Automate flows. Triggering these flows can be done using  from an event, button, schedule, or business process flow. Sign in to  Power Automate . Select  My flows  in the left navigation pane. Select  New , and then select  your desired type of flow . Give your flow a name in the  Flow name  box. Select  Create ,

Microsoft has come up with a boom by introducing UI Flows. UI flows helps you to automate the rework that you do on daily basis. For example, you might be doing Bidding on any freelancer site and maintaining data in a local excel. You at the end of the week/day want to submit data to some portal like dynamic365. You can also use this to send emails to list of people in excel. UI flow is the solution to help you with. Note: UI flows don't need any expertise with SharePoint/.NET or any other development language. Just prepare an algorithm and get started. What you need to get Started? Just download Power Automate Desktop. You just need to train your UI flow on what to mimic whenever flow is triggered. Power automate allows you to record your actions on windows as well as web browsers. You don't need any additional tool for recording windows/desktop actions, However you will need to add Power Automate add-in for recording actions to perform in browser. Supported Browsers - Firefox

W e can create Team Sites using Power automate. Use “Send HTTP Request to SharePoint” action for creating team site. To create Modern Team Site (No Group) We need to make a call to “/_api/SPSiteManager/create” end point. SiteDesignID parameter is optional. Your call should look like below when action is created.     Modern Team Site (Linked to a Group) We need to make a call to “_api/GroupSiteManager/CreateGroupEx” end point. Ensure to pass implicit formula parameter something like below. ["implicit_formula_292aa8a00786498a87a5ca52d9f4214a_7c13ef32-45f0-4282-a3c7-2d05ff0a9189"] Your call should look like below when action is created.   Thanks, Keyur Pandya

  H ope you are doing fine and safe in this pandemic situation. I recently came up with an opportunity to work with SharePoint Site Designs. SharePoint Site templates are now replaced with Site designs in Modern Sites.   SharePoint allows us to create JSON schema to apply our custom options that we want to add. Below are the things we can apply using site script. Create a new SharePoint list Define a new site column Define a new content type Add a navigation link Remove a navigation link Apply a theme Set branding properties Set a site logo Join a hub site Install an add-in or solution Register an extension Activate a Feature Trigger a flow Configure regional settings Add users (principals) to SharePoint Groups Manage guest access Let us assume we have a JSON schema created. I am taking below sample from MS documentation for reference.   We will now be adding above JSON schema to SharePoint as Site Script. Below is the command we execute. $site_script = ‘{   "$schema"