If you are using the free version of Power Automate that comes with your company Office365 account, and frequently use it to process SharePoint lists or Excel spreadsheets with a lot of rows, you may have encountered the 5,000 items looping limit error as below. This is a limit placed by Microsoft to separate free […]
Batch Processing in Power Automate Read More »
File backup is an important task we do everyday when dealing with business data, and SharePoint provides a quick and easy way to do that for every file you upload to SharePoint sites. By default, versioning is enabled for all lists and document libraries, thus whenever you make changes to a file, SharePoint will automatically
Automatically Back Up Files Across SharePoint Sites Read More »
CSV has been a commonly used file type to transfer large amount of tabular data from one system to another, given its simple plain text data storage and non-proprietary nature. However trouble comes when you need to break the CSV for data processing, either to create separate reports or to feed data into systems that
Parse CSV with SharePoint and Power Automate Read More »
As part of the user experience design, getting a real time instant response from the application interface could enforce app users’ sense of completion for their actions. Of course you can still use an email as the final confirmation on the outcome of an entire process, but for mini steps in between, a simple in-app
Simple In-app Notifications in Power Apps Read More »
A common scenario in using any application is to directly access a specific screen within the application without landing on the home page first. This feature is called Deep Linking and it greatly helps to improve the efficiency of the workflow. For example, if you want to show someone the Google search results of a
Deep Linking in Power Apps Read More »
It’s quite common to archive a file on a monthly basis. Though it is a very simple task, sometimes it is quite annoying to force yourself to remember doing so. So we can write a simple flow to automate this repetitive task. Choice of Flow and Trigger Because this is a routine task, the most
Archiving Files with Power Automate Read More »
Being a city-state, Singapore has developed a very comprehensive 6 digit postal code system and you can locate almost any places in Singapore by using the magical 6 digits. Building on it, the Singapore government took the digitalization initiatives to gather many useful day-to-day information and services contributed by various government agencies like ACRA, HDB,
Search Singapore Address with Power Automate Read More »
Sometimes business processes will need to know the location of the users and depending on the returned value, different actions will be taken. For example, Office365 retail version can only be activated in the region where it is purchased, and the data sharing from your WhatsApp client to Facebook does not work in India thanks
Geofencing in Power Apps Read More »
When building applications using Power Apps, there are occasions where we need to display a large piece of information to the user (such as User Policy, Privacy Statement, etc) or allow users to download a template file so later they can submit for batch processing (such as template batch file for SAP processing). In this
How to Download a File from Web in Power Apps Read More »
Sometimes you may encounter the situation where Power Apps just could not display all the content that you want to show to users, it could be a long article like User Policy or Privacy Statement, or some multi media content you want to play, or simply a third party service you want users to access.
Open a Web Page or Launch an Email Client from Power Apps Read More »
