Azure | Copy Data from CSV to SQL Server using Azure Data Factory, Azure Logic Apps and SharePoint Document Library
Binary Republik
by Nidhi Gadhia
2M ago
  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
Visit website
Add Customized Disclaimer message for developers before Publishing Power BI Report
Binary Republik
by Dhruvin Shah
3M ago
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
Visit website
Filter Records based on Date and Time Condition in Power Apps
Binary Republik
by Dhruvin Shah
4M ago
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
Visit website
How can we Pad 0 to Integer Values in Power BI?
Binary Republik
by Dhruvin Shah
5M ago
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
Visit website
[Issue Resolved]: You are not authorized to send mail on behalf of the specified sending account.
Binary Republik
by Mihir Kotak
5M ago
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
Visit website
How use SharePoint theme color in SCSS in SPFx
Binary Republik
by Sanjay Makwana
6M ago
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
Visit website
Close and Logout Power Apps using Exit() Function in Power Apps
Binary Republik
by Dhruvin Shah
7M ago
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
Visit website
How to use Fluent UI Icons in SharePoint Framework (SPFx)?
Binary Republik
by Sanjay Makwana
7M ago
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
Visit website
Invite External Users to a SharePoint Site / Add External Users to a SharePoint Group via Power Automate
Binary Republik
by Mihir Kotak
7M ago
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
Visit website
SharePoint Framework (SPFx) - How to add Request Header while using PnP for SharePoint List CRUD Operations?
Binary Republik
by Sanjay Makwana
7M ago
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
Visit website

Follow Binary Republik on Feedspot

Continue with Google
OR