A few days before, I was required to send an email containing project names and serial numbers. To achieve this, I used the range() function in Power Automate, which generates an array of integers. In this tutorial, I will explain how to provide a sequential serial number for a list of SharePoint items using the … Read more >>>
A few days before, I worked on creating an Event Registration form using the Power platform. For this form, we used a SharePoint list as a data source. To get the proper information from the users, I validated each field in that list, including the Phone number field. In this article, I will explain how … Read more >>>
I ran into an unexpected issue while working on a Power Automate flow. I needed to compare two dates: today’s date and a date five days in the future. I used the formatDateTime() function to format the dates, but when I applied the condition to check if today’s date was greater than today + 5 … Read more >>>
While working on a project named Employee Satisfaction Survey, I encountered a requirement to replace commas with new lines in Power Automate. Initially, I thought this could be easily achieved using the replace() function, which follows this format: However, when I tried using \n, char(10), or even HTML <br> tags as the newText Value, they … Read more >>>
Recently, we received a client’s requirement for Project Management on a SharePoint site. One requirement was to create a Gantt chart view in modern SharePoint lists using JSON code. So, I thought I would share my knowledge about the Gantt chart views in SharePoint in this article. In this blog post, I will thoroughly explain … Read more >>>
Recently, while working on a Power Automate project, I faced a requirement to extract numbers from a string. This came up when dealing with a SharePoint list where some fields contained a mix of text and numbers, and I only needed the numeric values. After researching and testing different approaches, I found an effective way … Read more >>>
Recently, while working on a Power Automate Flow to generate a PDF from SharePoint list items, I encountered a challenge: some numerical values stored in my SharePoint list were in text format instead of numbers. This became a problem when I needed to perform calculations, as Power Automate treats string values differently from integers. If … Read more >>>
Recently, while working on a Power Automate Flow to Generate a PDF from SharePoint List Items, I encountered a challenge formatting number as currency. The default number formatting didn’t quite meet the requirements, so I researched and found a few practical ways to achieve this. In this tutorial, I will tell you how to format … Read more >>>
Did you know how to work with a List box control in Power Apps? If not, I hope this Power Apps tutorial will help you understand everything about Power Apps List box control and its uses. Additionally, we will learn key properties of a Power Apps list box control and how to add a list … Read more >>>
I built a Power Apps Employee Satisfaction Survey a few days ago. In that app, while creating a dashboard, I was required to perform many actions, such as displaying the employee surveys in gallery control and applying multiple filters. I was required to use Power Apps Container Control to achieve a flexible layout and adjust … Read more >>>
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…