Microsoft • Page 8 of 11 • Tomasz Poszytek, Business Applications MVP

Nintex Workflow for Office 365 Office 365 Power Automate SharePoint Online

Discovering suspended workflows with Microsoft Flow

In my daily work over business processes in Office 365, specifically in SharePoint Online, one thing annoys me the most – namely the lack of mechanisms to inform me that the workflow has hung up – that it is in a “Suspended” state.

The solution for that issue is not provided by Microsoft or Nintex – the company with which products I have been working for a quite long time. There are only workarounds, but they are inadequate, and I wanted to be able to react proactively and not reactively to any flow suspension event.

March 2, 2019

Office 365

Microsoft Flow is not only for business

This post is not about solving problems. Or business real life case-studies. This post is about what can you do with tools from Office 365 suite. I am documenting here the solution I built to make my home a little smart and to make my life easier.

January 27, 2019

Power Apps

End user receives pop-up asking for permission when launching PowerApps

I’m a big fan of working with PowerApps and creating business solutions using that tool. Until last week I wasn’t aware, that when I use specific permissions to access data sources (SharePoint in that case) inside my app, the end user who is going to use that app will be asked for permissions, to be able to use that application.

December 27, 2018

Power Apps Power Automate

PowerApps hand written signature

Customer asked me if this is possible to add handwritten signature to a PDF generated using tools available in Office 365. My first thought was “no”, then I checked that there is “Pen input” control in PowerApps, so it was like “yes”. Then again, after searching “how” this signature can be put inside a document, I thought this is a “no”.

December 3, 2018

Power Bi

Power BI DATEDIFF only working days, hours and so on…

I recently found myself in a situation, when I needed to calculate a date difference between two datetime values in Power BI excluding weekends. The request seemed first as an easy thing, until I found out, that Power BI doesn’t have any function allowing to achieve it easily.

October 26, 2018

Power Apps Power Automate

Removing records in SharePoint from PowerApps

PowerApps is getting more and more powerful tool to create business apps in the “no-code” approach. Using SharePoint as the data source is somehow natural (although there are alternatives, like an SQL Server or Common Data Service) thanks to their tight integration.

September 10, 2018

Power Apps Power Automate SharePoint Online

Clear lookup and people picker fields in PowerApps

Have you ever been struggling with a lack of the possibility to clear a number, person or lookup column using PowerApps? Well, I recently found myself in a situation, where I needed to be able to clear such columns in my application, but found out, that this is not possible (maybe not yet).

June 14, 2018

Office 365 Power Automate SharePoint Online

Facebook @workplace integration with SharePoint using Microsoft Flow

Building an intranet using modern SharePoint I was asked by a customer, if this is possible to show information from their facebook @workplace portal. I started digging and reading the documentation only to realize, that no matter if I were using modern or classic approach, still there are no ready-to-use scripts from facebook, allowing to copy-paste and then be able to display ex. information from Newsfeed.

May 23, 2018

Azure Office 365 Office 365 Groups Power Automate

Add Office 365 group members using Microsoft Flow

This may seem trivial, but if you want to create a Flow, that is parameterized, where a name of a group and list of members is passed as the request parameters then it turns out it is not that straightforward.

In Microsoft Flow there is a set of actions, that allow to work with Office 365 Groups. There is also one dedicated to adding new members (only “Members”. There is no way currently to add “Owners”).

April 28, 2018

Discovering suspended workflows with Microsoft Flow

Microsoft Flow is not only for business

End user receives pop-up asking for permission when launching PowerApps

PowerApps hand written signature

Power BI DATEDIFF only working days, hours and so on…

Removing records in SharePoint from PowerApps

Clear lookup and people picker fields in PowerApps

Facebook @workplace integration with SharePoint using Microsoft Flow

Add Office 365 group members using Microsoft Flow

Migrating Nintex repeating section to Power Apps

Managing Power Apps Offline Access with M365 Security Groups

Replace special characters using Power Automate

Unlock and lock Excel spreadsheet using Office Script

Save XML data to SharePoint list dynamically