How to secure HTTP request end point for external or 3rd party application?
How to secure HTTP request end point for external or 3rd party application ?
How to transform data stored in SharePoint list using Power Automate?
Use Case In this article, we will learn how we could transform data in SharePoint List using power automate cloud flow. We will take an example of transforming data in SharePoint to generate timecard or timesheet. Scenario & Sample Input data All tasks & corresponding hours performed by the users are stored in custom SharePoint […]
How to convert CSV file to array of JSON objects?
Use Case Today, we will learn how to convert csv file to array of JSON object without using ‘Apply to each’ as it not the optimum action when using a large csv file. Scenario & Sample data We will take an example of an incoming email with csv file as attachment. The flow will convert […]
Join arrays efficiently without using loops in Power Automate
Use Case Usually, we come across the problem of joining the arrays. One most common case is “left join” where resultant array contains the matched values and if second array does not have the matching value then it stores blank or empty value in the final result. I will show you the way to perform […]
Filter single select choice field by label text in Dataverse
Use Case Recently, I came across a problem of filtering the records by choice text (label text) from Dataverse table. This is a common query posted by users in Power Platform community. So, I decided to write this blog and explain the ways to address this problem. Please note that below solution will work only […]
Extract data from html table from email body in Power Automate
Use Case I have found that there are many posts related to extract data from html table in the email body. This is the common scenario when organization tries to automate the process to increase personal productivity of users. So, I thought of sharing a solution to accomplish this task. Scenario Let’s take an example […]
Single consolidated email to user (owner) for single select user field in SharePoint
Use Case Many a times, we need to send a single consolidated email to user for the list items present in SharePoint. It may be a reminder with table of pending tasks assigned to a user or sending email to manager with team details etc. Here, I will take an example of Tasks list which […]
Extract all the text in photos and PDF documents (OCR) – AI Builder template loop optimization
Use Case Recently, we had the requirement to extract data from scanned pdfs or image files. So, we had chosen prebuilt AI model (Extract all the text in photos and PDF documents (OCR)) for extracting the data or content for that purpose. The prebuilt AI model are ready made models that can be used in […]