Quite a few years back I wrote a post about reading CSV files in Power Automate. But that can be done so much better now. An imagine having to deal with commas, you would end up with ugly expressions.

Power Apps, SharePoint, and Power Automate work seamlessly together to handle business data. A common requirement is to store structured list data from Power Apps ...

One should be familiar with SharePoint Online (SPO) lists, how to create them and modify their views (look and feel as well as formatting). One should also be familiar with JSON and how leverage it to ...

We are pleased to announce the experimental release of our ParseJSON function, which can parse JSON strings into Power Fx objects and types. This new function dramatically simplifies working with JSON ...

Microsoft Lists doesn’t replace Microsoft To Do or Planner, but it might edge out Excel for information management. Also, Microsoft Lists is now available on Android. Using spreadsheets as databases ...

This week we have a special FOTW From one of our MVP’s – Paul Culmsee! Paul Culmsee (@paulculmsee) is a management and technology consultant, Microsoft MVP and ...

You can use column and view formatting to customize how fields in SharePoint lists and libraries are displayed. To do this, you construct a JSON object that describes the elements that are displayed ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...