-
How to take lastn / second, third, n word from phrase / sentence (string) in Power Automate
Hello, In this short article I will provide clear instruction how to take for example second from the end word from sentence “I am Rafal Kobus” in Power Automate. Let’s say that we have our dynamic value in outputs(‘Compose’). Firstly we have to split phrase by spaces or other sign to have an array. Then… Continue reading
-
How to convert e-mail / html to PDF with spacing with standard license in Power Automate
Quick flow that converts all .msg files stored in a folder (you can amend that to HTML) to PDF including spaces and formatting. There is no need to use premium components of Power Automate Cloud. All steps are presented in below screenshots: Continue reading
-
Select one column from excel with variable
Hello, I would like to present you with, a ready-to-use solution for small bunches of data taken from Excel Workbooks via Power Automate Cloud, where you would like to limit taken columns to one of them, without knowing the full column name. Of course, to make everything harder, Excel Workbook’s table is also given as… Continue reading
-
Reordering columns in Power Query without errors
Here you can find easy-to-apply steps that will help you with changing data sources and reordering columns steps. As you probably know, your query can have only one reorder step, at the end for example. All reordering steps can be deleted once you finish building your query. There is a risk that your query will… Continue reading
-
Split PDF file to single page PDF files
This Python script imports the PyPDF2 library, which provides a way to manipulate PDF files. The script then uses the PdfFileReader and PdfFileWriter classes from this library to read and write PDF files. The script first imports the necessary libraries and sets the current working directory to the directory where the script is located. It… Continue reading
-
How to create a flow for reminding me about the upcoming date from the Excel
The easiest way to create a simple reminder Power Automate flow to notify users / users about upcoming dates is described below. Pre-design requirements Excel file must be stored in OneDrive/SharePoint Data must be formatted as Table Date column must be formatted as Date if(empty(<DATE TO CONVERT>),null,addDays(‘1899-12-30′,int(<DATE TO CONVERT>),’dd-MM-yyyy’)) is equal to addDays(utcNow(),<number of days… Continue reading
-
Scheduled export from Power BI dataset to Excel
In this post, I will present how to achieve scheduled export to xlsx (Excel) from the Power BI dataset using Power Automate without ‘apply to each’ step. First, we have to prepare a dataset to be serviced by flow by publishing that to Workspace. After that, we create a scheduled flow with our requirements. The… Continue reading
-
Welcome!
Welcome to our WordPress blog focused on Power Platform, Excel, and VBA solutions! We are excited to share with you our expertise and knowledge in these areas to help you enhance your productivity, streamline your business processes, and automate your work. Our team of experts has a wealth of experience in using these technologies to… Continue reading
About Me
As a power platform fan and developer of solutions that can help in daily tasks, I have a deep understanding of how technology can be leveraged to make everyday work more efficient and effective. With a passion for automation and optimization, I am always looking for new ways to streamline processes and save time. I have a strong knowledge of the power platform, including Power Apps, Power BI, and Power Automate, and I am skilled in creating custom solutions to solve specific business needs. My expertise and enthusiasm for the power platform make me an invaluable asset to any organization looking to enhance their productivity and streamline their workflows.
Recent Posts
- How to take lastn / second, third, n word from phrase / sentence (string) in Power Automate
- How to convert e-mail / html to PDF with spacing with standard license in Power Automate
- Select one column from excel with variable
- Hide SharePoint List from Search & Power Platform drop-downs
- Reordering columns in Power Query without errors