Development

Power Apps

How to bulk update SharePoint data from Power Apps Patch vs UpdateIf vs ForAll

I was asked about bulk updating SharePoint data, so here's a note on how to do it. I also did a performance comparison. ...
Power Apps

How to write a clean Filter function in Power Apps|Discussion of problems with the way it has been written in the past.

I have learnt how to write neatly when applying Filter to a gallery, and I have made notes on how I have tried and teste...
Power Apps

Relationship between the AddColumns function and delegation in Power Apps|DropColumns and ShowColumns also only allow the gallery to display up to 500 items.

When using AddColumns for the gallery, I had been feeling a slight discomfort for some time, so I did some research and ...
Power Apps

Using PDF functions in Power Apps (preview) – creating and viewing multi-page PDFs, saving files, email attachments

PDF Functions PDF functions are functions that were released as ‘experimental functions’ and allow the creation of PDF f...
Power Automate

Using Word connectors from Power Automate to create documents|Replacing text, adding dynamic items and creating PDFs.

The Word connector action gives the impression that it is not used very often because it requires a premium licence. I h...
Power Apps

How to convert Word, Excel and Power Point files to PDF using only the Power Apps canvas.

I found this article interesting and tried it out. Advance preparation The assumption is that the file needs to be in th...
Power Apps

How to turn Word, Excel and Power Point previews into Power Apps canvas apps.

I found this article interesting and tried it out. Advance preparation Save sample files in the SharePoint document libr...
Power Apps

Getting the ‘item count’ of SharePoint lists with more than 2000 items in the Power Apps Canvas app.

Because of the ‘data row limit’ and the ‘delayed loading feature of the gallery’, it was difficult to get the number of ...
Model-Driven Apps

Changing the status of flow steps in the business process flow of a model-driven application from ‘Processing’ to ‘Successful’.

Notes on how to change the state of a step from ‘processing’ to ‘successful’ when executing a flow step of a business pr...
Power Automate

How to set a value in the User column of a SharePoint list in Power Automate with an email address, and how to set null.

Note how to set a value in the SharePoint user column from Power Automate by specifying an email address. Person or Grou...