Introduction: We created a process to copy data from CSV file uploaded in SharePoint Document Library to SQL Server Database for a Drug Dispensary based out of Pennsylvania, USA. For this, we created a Document Library in SharePoint Site where the user uploads the CSV file, so when a file is uploaded in the SharePoint Document Library, the Logic App captures the File that has been uploaded, and the content is passed from the Logic App to the Azure Data Factory for further processing. The Azure Data Factory has a copy data pipeline, which copies the Data of CSV to the relevant SQL Table ..read more

Overview: In this blog, we will talk about how we can customize a Publish message in Power BI Desktop. This tip will help us to provide a disclaimer to our end-users before they publish any reports to Power BI Service. So, now let’s get started! Open your Power BI Service account. Go to Admin Center. Go to Tenant Settings and expand “Show a custom message before publishing reports” Turn on the feature and add the following custom message. You can add any message based on your customization. #### Important Disclaimer Before publishing the report to a workspace, make sure the user is a ..read more

Overview: Consider a scenario, where you are moving your Power Apps to the production environment and we only want to show records after our Production Launch! Let’s say, Production Live happened at 01:00 PM then we need to show records created after 01:00 PM on that day. So, how can we achieve this?  Solution: We need to use the following Power Fx formula to achieve this! DateValue Time function with Hour, Minute, and Second Consider the following example: Below is the screenshot for List Items. We need to show records that are created only after “07/26/2021 01:00:00 PM”.   ..read more

Overview: Sometimes we have a requirement, where we need to Pad “0” to our numeric value. There are multiple ways to implement this. But we will go with the simplest and easiest one! So, let’s get started! Step 1: This is our Sample Data Source, where we have Project ID, Project Name, and Hours column. Now, we want to pad “0” before our Project ID column and need the end outcome like the following. So, how can we achieve this? Step 2:  - Open Model View of Power BI Desktop and select the “Project ID” column.  - From Format, select “Custom”.  - Under Custom Format ..read more

Introduction Recently, while working on a Power Automate Flow, we came across a requirement to send an email from another user. We used the “Send an email (V2)” action.  In this action by clicking on “Show advanced options” we configured the From (Send as) field. But the flow run failed. The error message below was displayed: "You are not authorized to send mail on behalf of the specified sending account." This means to use this option we are required to have "Send as" or "Send on behalf" permissions granted to the account using which the “Send an email V2” action is configured.  ..read more

Introduction: In this blog, we will learn how can we use the color of current applied theme in SharePoint in SPFx web parts or SPFx extension. Steps: Step 1) Go to the SCSS file of your web part or extension. Step 2) Now at the top of the SCSS file, declare the variables and assign the theme color as a value to this variable as given below: $themePrimary: '[theme:themePrimary, default:#dc1928]'; $themeSecondary: '[theme:themeSecondary, default:#2488d8]'; $themeTertiary: "[theme:themeTertiary, default:#69afe5]"; $themeLight: "[theme:themeLight, default:#b3d6f2]"; $themeAccent: "[them ..read more

Overview: Sometimes, there is a requirement, wherein we need to close our Power Apps and Logout the user from the App’s context. How can we achieve this requirement?  Power Apps provide one Power Fx formula to achieve this which is the EXIT() function! So, now Let’s explore this feature in detail!! We have created one Power Apps with two buttons. First, let’s check the syntax! Syntax: Exit([Signout])  Here Signout is an optional parameter that accepts a Boolean value.  If we pass true, then, it exits from the app and signs out the user! Let’s get started! Step 1: Add bu ..read more

Introduction: In this blog, we will learn how we can use Fluent UI Icons in SPFx Webparts or SPFx Extensions. Here are the steps to use Fluent UI icons: Steps: Step 1) To use the Fluent UI icons, first we need to install the package for Fluent UI using the below command.  npm i @fluentui/react Step 2) Now, we need to import Icons and Iconsprops as given below: import { Icon } from '@fluentui/react/lib/Icon'; Step 3) Now, declare the global variable and assign the icon as given in the below code. Here we are using a global variable so we can use this icon multiple times. co ..read more

Introduction In this blog, we will demonstrate how we can programmatically add external users to a SharePoint Group without using Azure Application and User.Invite.All permission with the help of Power Automate.  Solution Firstly, we will create a JSON object that will contain the data that we need to add a new external user to a SharePoint Group as shown in the below image.  Replace the highlighted content in the object below: { "url": "https://tenantname.sharepoint.com/sites/sitename", "peoplePickerInput": "[{\"Key\":\"Email Address\",\"DisplayText\":\"Email Addr ..read more

Introduction: In this blog we will learn how can we add the Request Header while using PnP in SharePoint Framework (SPFx) web parts. Problem Statement: When we use the Fetch or Ajax requests in SPFx, we have option to add the Request Header to the REST API requests we are using, but when using PnP, there is no option to add the Request Header while performing CRUD operations in SharePoint. For example, while using Fetch Request to get the list items, we can add the header as give in below code snippet: return fetch(APIUrl, { credentials: 'same-origin', headers: { 'Acce ..read more