Contact

By

Popular posts from this blog

How to Upload Files from Microsoft Forms and Save them in a SharePoint Library

By
Image
We will walkthrough the process of uploading files from Microsoft Forms and saving them directly to a SharePoint document library. By integrating these two powerful tools, we can streamline file management and data collection workflows. Let’s get started! Prerequisites : Before we begin, make sure you have completed the following preparations: Create a Microsoft Form with an upload field to collect files from users. Set up a SharePoint document library where you want to save the uploaded files. Create a Power Automate flow to facilitate the integration between Microsoft Forms and SharePoint. Step 1: Create a Microsoft Form Upload File (upload) Accessibility (choice) Step 2: Set up a SharePoint Library Name (Built in Column) Accessibility (Single line of text) Step 3: Build the Power Automate Flow Create a new Automated cloud flow Choose trigger “When a new response is submitted” from the Microsoft Forms connector Select the Title of the Form from the dropdown list Add “Get Response Det...
Read more

Validate Email Format in Power Automate Using Custom Connector and Regex in C#

By
Image
Validating email formats in workflows is important to pre-check the data before using it in business logic and to avoid errors. While Power Automate has many actions, it doesn’t include advanced email validation by default. In this blog, you’ll learn how to create a  Custom Connector  to validate email addresses using  C# code and Regex . High-Level Solution: Create a Custom Connector  in Power Automate that uses C# and Regex for email format validation. Use the Custom Connector  in Power Automate flows to dynamically validate email addresses. Steps to Implement: Step 1: Create the Custom Connector 1.1 Create Blank Custom connector Log in to  Power Automate . From the left menu, select  Custom Connectors . If not visible, go to  More  >  Discover All  > Locate  Custom Connectors  under the  Data  section. Click on  New Custom Connector , then select  Create from Blank . 1.2 General Configuration E...
Read more

Creating a CSV File with Byte Order Mark (BOM) in Power Automate

By
Image
In Power Automate, creating a CSV file with a Byte Order Mark (BOM) can help ensure compatibility with applications that require UTF-8 encoding. This guide will walk you through setting up a flow that creates a CSV file with BOM in OneDrive. Step-by-Step Guide 1.Create an Instant Flow Start by creating an Instant Cloud Flow in Power Automate. Click New flow > Instant cloud flow > Enter Flow name Select Manually trigger a flow > Click Create 2. Initialize CSV Data Variable with Sample Data Add an Initialize Variable action. Set Name to varCSVData . Set Type to Array . In the Value field, enter your sample data directly, like this: Optionally rename the action : Initialize varCSVData [ { "Name" : "John Doe" , "Email" : "john@example.com" , "Country" : "USA" }, { "Name" : "Jane Smith" , "Email" : "jane@example.com" , "Country" : "Ca...
Read more