Using a Canvas app with Dynamics CE to upload an image

By | January 23, 2019

 

You probably know that we can extend entity forms with the canvas apps – this feature has been in the preview for a while now:

https://docs.microsoft.com/en-us/business-applications-release-notes/october18/powerapps/extend-dynamics-365-entity-forms-with-embedded-canvas-apps

It would be interesting to find some useful application for this new functionality, so I figured why don’t I use it to add “image upload” area to a form?

Here is what I ended up with:

powerimage

Quite frankly, it took a while. A few hours.. But, also quite frankly, it took less than it might have taken me if I had to actually do some coding there. Although, this whole solution is not without its own limitations, so there are pros and cons, but, as you can see above, at the very least it’s viable.

Here is how it’s been set up:

  • There is a list in sharepoint, so those files are stored as attachments on the list
  • That list has an extra column (RecordId, string). That’s what my PowerApps application is using to identify the list item related to the currently open contact record in Dynamics

 

On the application side, I have my main screen and a form right on that screen:

image

You can see that there is, also, a Timer control. Somehow, I cannot really use filter/lookup functions in the OnStart/OnVisible of the screen control but it works perfectly when done in the timer.

So the timer (which will run only once) is doing this:

image

It will set a variable, and, then, depending on whether a sharepoint list item exists, it will either call EditForm or NewForm.

My form “DATA” properties are set like this:

image

I’m using SelectedContactId, but I have to use a LookUp there, too, since, otherwise, the form does not get refreshed properly on the updates (Could have used a variable.. but the variable needs to be refreshed when a file is added/removed)

Attachments card has two controls. There is an attachment control which I’m using to add files, and there is an Image control which I’m using for the preview of the image. On the screenshot below, you’ll see how Image property of that control is set:

image

And, finally, whenever a file is added/removed, I need to submit the form and refresh it. So, I’m doing exactly the same in the attachment control OnRemoveFile and OnAddFile events:

image

So how is this new file linked to the record in Dynamics? Remember in my sharepoint list I have “recordId” column – – you’ll see I’m using it on the screenshots above to do a LookUp on the Files datasource. That RecordId is always set to the ID of the record, but the control itself is not visible on the form (no point displaying the guid there):

I think it took me more time to figure out how to work with all these screens/controls/events/etc than to actually write an app for this particular use case, and, yet, it only took a few hours. Not bad, it seems?

And just a couple of notes for the conclusion:

 

Not sure how to end this post.. Happy Power Platforming, I guess?Smile

Leave a Reply

Your email address will not be published.