Get SharePoint Library or List Total Items from Power Apps

frustrated because you have no way of determining the total number of items in the data source should said data sources contain more items than the Data row limit configured for the app for non delegatable queries (being between 500 – 2000)? If so this blog may be just what you’ve been looking for.

Continue Reading →

Viewing Word, PowerPoint & HTML files stored in SharePoint in Power Apps v2 – cached PDFs

Wouldn’t it be cool if you could view Word, PowerPoint & HTML files stored in SharePoint in your Power Apps in the PDF Viewer control with nothing more than a single expression / formula on the Document property of the control. One line of code, no Power Automate flow ?. That’s it. v2 – Viewing documents updated in SharePoint

Continue Reading →

Viewing Word, PowerPoint & HTML files stored in SharePoint in Power Apps

Wouldn’t it be cool if you could view Word, PowerPoint & HTML files stored in SharePoint in your Power Apps in the PDF Viewer control with nothing more than a single expression / formula on the Document property of the control. One line of code, no Power Automate flow ?. That’s it.

Continue Reading →

Alternate techniques to view all types of documents stored in SharePoint Document Libraries within PowerApps

In this blog four alternate techniques are outlined that enable App Makers to render the practically any type of document stored in SharePoint Document Libraries in PowerApps

1. Actual PDF documents ( Basic Flow )
2. Word documents, PowerPoint presentations, HTML files (and numerous other document types) converted to PDF documents on-the-fly
3. Thumbnail images of the documents generated on-the-fly
4. Actual PDF documents
( Advanced Flow with Graph APIs )

Continue Reading →

Dataverse virtual connector provider for SQL Server. Awesome?

I am genuinely excited at some of the opportunities in creating solutions that could potentially leverage the new Dataverse virtual connector provider functionality / features being released. For that reason I’ve spent a substantial amount of effort evaluating this feature and documenting my own learnings by way of this blog as I believe other people equally interested may find at least some of my insight shared extremely useful for them.

Continue Reading →