Category: PowerApps

PowerApps export as package fails due to missing connections

PowerApps

Sometimes when we are working with PowerApps, adding new connections like to Microsoft Flow or external services and then we decide we don’t need some of them anymore and therefore we are removing it, but forgetting to first delete it in PowerApps, we are finding ourselves in situation, where when trying to export the app as a package, we are facing a very hard to debug issue.

(more…)

Sketch-noting in PowerApps and merging images

PowerApps

Post was inspired by a comment with a question posted some time ago under the post about hand written signatures. Kevan asked, if this is possible to take a photo, then sketch-note on it and finally save two images as a single one.

(more…)

Import XML to PowerApps

PowerApps+Flow logo

When preparing for a new project, I started to check whether different customer expectations are feasible with PowerApps. The first of these is the ability to use an XML file as input, to build a table in the application and possibly to save them to SQL later.

(more…)

Importing PowerApps package as a SharePoint list form

PowerApps

The functionality in PowerApps allowing to export an application and then import it in a different environment or to migrate it this way to your customer’s tenant is known. However this works like a charm when talking about standalone apps. Is it possible to import a list form made in PowerApps as well? Yes! Maybe not very straightforward, but yes.

(more…)

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

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.

(more…)

PowerApps hand written signature

PowerApps+Flow logo

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”.

(more…)

Removing records in SharePoint from PowerApps

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.

(more…)

Clear lookup and people picker fields in PowerApps

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).

(more…)

How to: Import data from XLSX file into SharePoint Online using Nintex

In Nintex 2010, 2013 and 2016 for SharePoint (Standard version even) on-premise of course, there was a possibility to use Excel Services to query and work with the xlsx and xls files’ data. However, in Sharepoint Online there is no such powerful mechanism (well, there are Excel Services available via REST API, but it doesn’t provide that much functionality). Moreover Nintex products for SharePoint Online (neither Nintex Workflow Cloud nor Nintex for Office 365) don’t have any “OOTB” actions that would fill that gap. So in the end, there is no straightforward way to achieve it. So how can I import (and preferably automate it) data from XLSX file into SharePoint?

The most common workaround is to convert the xlsx file into a plain, csv file and then to work with the data from the file using collections (I will write about it in second post).

Recently I have realized, that there is a set of Excel actions in Microsoft Flow! All of us, who has SharePoint Online, has also a free version of Flow available. 

(more…)