Enterprise users, especially those involved with the digitalization of existing processes, might be faced with the requirement to fill out certain standardized forms with Power Automate and make these available to the respective stakeholders.

Microsoft offers a Populate a Microsoft Word Template action right out of the box in Power Automate, but for many organizations, using Premium Connectors is not feasible due to company policies.

There is a simple solution: We can create a workaround for filling out forms and offering them as a *.pdf with a SharePoint Document Library and a Power Automate Flow.

When creating Canvas PowerApps, developers might face the requirement of including values of SharePoint’s Calculated Columns eventually. However, if you have worked with PowerApps before, you might know that the data types are not consistent between SharePoint and Power Apps when it comes to the type Number. That situation can leave developers with quite the headache:

"Help! — I have created a Calculated Column in a SharePoint List, but when I want to display the value inside my Power App, a lot of trailing numbers are added. What can I do?"

• Someone working with Calculated columns of type Number in PowerApps

There is a simple solution: Convert the property to a data format Power Apps can work with. Depending on your setup, there are two different approaches.

Enterprise users frequently request mass data import features for their Power Apps. While there are various data exchange formats, *.csv files remain one of the most popular, especially due to their ease of use. However, if you’ve worked with Power Apps, you will know that there is no out-of-the-box solution for loading/importing *.csv files. This can leave Power Platform Architects with quite a headache.

There is a simple solution: Power Apps and Power Automate can easily read *.csv-files together, providing a simple way to mass import data. They are in one ecosystem and collaborate nicely.

The following step-by-step guide will walk you through how to load *.csv files in Power Apps using Power Automate. Let’s get started.

With the world becoming increasingly urbanized [1], public transport has become an omnipresent part of urban life. The probably most urban place in the world is Tokyo [2] — a bustling Megapolis of an unmatched size where most people primarily rely on public transport [3] in their everyday lives.

Storing and processing data is an elementary task of software engineering. In the early days of large-scale professional development, relational databases such as Oracle, IBM DB2 and SQL were dominant. Data manipulation systems cannot easily work with structural or relational data, but only with flat data representations. [1] Graph databases try to bridge the gap between relational and flat data representations, while making it easier to access information. [2] The most popular representative of this type of database is Neo4j. [3]

In some cases, external services need to use employees’ identities - especially profile pictures. There is probably no more central place than Entra ID to acquire profile pictures.

Example: We are setting up an external, premade solution that lacks out-of-the-box integration with identity providers. And along with metadata, we may also want to transfer profile pictures into our solution.

Luckily, most organizations have an identity store that we can utilize. In our case, we can use Office 365 with its Entra ID. With these tools, we can easily access the necessary data to build our feature.

In this article, I will share how to authenticate with OAuth 2.0 on Office 365’s SharePoint Online platform. The process includes registration of an app on Entra ID with certificate authentication, obtaining an OAuth 2.0 access token via .NET, and authenticating to SharePoint Online’s REST Services using the access token.

This is the first post of my blog. On this blog, you will be provided with frequent updates on personal projects & occasional results of my (hobby) data science research.

If you have any questions or concerns, just reach out to me via one of the linked social media platforms.

Thank you!