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 »
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 »
Author: Rik de KoningOriginal Post: https://www.about365.nl/2019/08/08/view-sharepoint-item-version-history-in-powerapps/ Sometimes when you’re building a PowerApp with SharePoint as your datasource, you want your users to only use the PowerApp and not to go to SharePoint directly. In this scenario it may come in handy to provide the user with the option to view the version history as well,
View SharePoint item version history in PowerApps Read More »
Author: Serge LucaOriginal Post: https://sergeluca.wordpress.com/2018/10/28/microsoft-flow-advanced-tutorial-creating-a-csv-converter-from-scratch/ A couple of days ago, one of my friend challenged a group of “flowers” to come up with a Flow that converts a CSV file to whatever you want, in this specific case to JSON objects that can easily be treated by Microsoft flow. Even tough flow can do it,
Microsoft Flow : Creating a CSV to JSON Converter From Scratch Read More »
