Answered

Including image data in submitform

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a form for recording new entries on a Petty Case Sharepoint list. The form contains a few datacards (which work fine) and I am trying to include a camera option to take a photo of the receipt (which isn't working).

I had been using SubmitForm with just the text and number datacards, but have hit a bit of wall when trying to include an ImageData dadatcard or using the attachment facility.

I've experimented with a few options I have found online and have managed to get the camera on its own to work on a test screen using: Patch(BH_PettyCash,Defaults(BH_PettyCash),{'Description (Title)':TextInput2.Text,ImageData:First(cmrImg).Url}) **This employs a text box which is not required in my form, but again I'm not sure how to remove this from the formula.

I have also adjusted the Sharepoint list so that clicking on Title brings up the photo as well in the edit screen, so any soultion hopefully won't change this.

So my question is: how do I include the image taken by the camera in the SubmitForm (or Patch)?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Are you trying to upload the captured image to a Picture column or as the attachment of an item?

If it's the former, I afraid that there is no direct way to achieve your needs in PowerApps currently.

As an alternative solution, you could consider take a try to pass the captured pictures (using Camera control) to a flow, then use the flow to create an attachments to corresponding SP list item. Please check and see if the following blog would help in your scenario:

Please check and see if the following blog would help in your scenario:

https://www.techmikael.com/2017/05/an-even-more-clever-workaround-for.html

If it's the latter, then I think the only way to add attachments to SharePoint list item is using Attachments control.

More details about uploading images using Attachments control, please check the following blog:

https://powerapps.microsoft.com/en-us/blog/add-attachments-to-sharepoint-lists/

Regards,

Mona

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-monli-msft
Thank you for your reply.
I've attached a screen shot of the Sharepoint list I've set up and the app screen I would like to use.
I've copied the url into the ImageData column of the Sahrepoint list to test that the image comes up when you edit the line, which it does (as we will need this for auditting purposes).
As I said I have been able to upload the photo url to the ImageData column (which is multiline text) using the Patch function in isolation on a test screen which I found in a very helpful YouTube video.
I have also seen in the Budget Tracker template that it is possible to use the camera like this, but in that template the camera is again on a separate screen which I would rather not do if avoidable.
If absolutely necessary I could move the capturing of the receipt image to another page, but how would I ensure that the ImageData went to the same line that SubmitForm had populated on the 'Add New Item' page?

Was this reply helpful? Yes No
Lars4 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you try to add a "AddPicture" Control to the Datacard of your image column? Then you can take a photo and the BlobStorage address is saved in this text column.

However, If you want to stay with taking a photo on another screen, you could store its Base64 in a global variable and set this global variable as Default Value of the image column in your form. This way you ensure, that the photo comes to the right line.

(I prefer the second scenario. And if you have some place left on the screen with the form, you can also do it on the same screen - or you can scroll as well)

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for everbodys help which has helped me sort this out and understand DataCards more.
After much experimentation I found a solution that worked: I included the DataImage as a field of the DataCard and then added the Camera function and an Image box to the DataCard. Then I made the DataCardValue equal Camera1.Photo. Whenthe form was submitted it saved all the fields, including the DataImage information. Problem appears solved 🙂

Was this reply helpful? Yes No