Optimize loop in Power Automate
Use Case String parsing is a common scenario when building workflows to solve business problems. In this article, I have taken a complex problem of extracting number from a given string. I will demonstrate how we can create a utility flow by using expressions, select & filter actions to perform the extraction operation. Scenario An […]
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 […]
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 […]
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 […]
