Posts

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...
Post a Comment
Read more

Integrating ServiceNow with Power Automate via REST API

By
Image
In this article, we’ll explore the integration process of ServiceNow with Power Automate using the REST API and OAuth 2.0 Resource Owner Password Credentials, accompanied by an illustrative example — retrieving Service Request details from ServiceNow using Power Automate. Power Automate includes a built-in ServiceNow connector. In this blog post, we’ll explore an alternative method for establishing a connection with ServiceNow. Prerequisites: ServiceNow Instance:  Access to a ServiceNow instance with the necessary permissions to create and manage API integrations. Power Automate Account:  A Microsoft Power Automate account to create and manage automated workflows. Step 1: Register OAuth Application in ServiceNow Start by logging into your ServiceNow instance. Search for “ Application Registry ” and select the corresponding option. 3. Click on “ New ” 4. Select “ Create an OAuth API endpoint for external clients .” 5. Name your application (e.g., PowerAutomateApp) and leave the...
Post a Comment
Read more

Step-by-Step Guide to Retrieve Data from SharePoint List with Over 5000 Items

By
Image
Managing large datasets in SharePoint lists can sometimes be a daunting task, especially when the list contains more than 5000 items. SharePoint imposes a limit on the number of items retrieved in a single request In this article, we will walk you through a step-by-step approach to retrieve data from a SharePoint list containing more than 5000 items. Understanding the Concept: 1.  Sending HTTP Request to SharePoint REST API:  To retrieve data from a SharePoint list, we’ll be utilizing the SharePoint REST API. 2.  Managing Data Exceeding 5000 Items:  SharePoint imposes a limit of 5000 items per request when querying a list. However, when the list contains more items, the HTTP response includes a property called  __next . This property is a URL that points to the next batch of records, enabling us to fetch data beyond the initial 5000 items. Steps: 1. Create a Power Automate Instant Flow 2. Initialize a boolean variable named ‘ varNextPageExists ’ with the value...
Post a Comment
Read more