Expense report receipts from Powerapps to Dynamics 365 Finance and Operations

Like (0) Share

Report

Posted on 12 Feb 2020 08:44:23 by CathrineB

Hi Community,

I am currently working on an expense report app connected to Dynamics 365 F&O and have a question. I have read plenty of blogs and documentation on how to send pictures from Power Apps to a data source, but i haven't yet fully figured out how to achieve this when adding a file or picture from Power Apps to an expense line in F&O using the "Add picture" function. I know it is easily done with power Automate when using the capture photo/media function, but my problem, along with many others, is that the "Add Picture" function stores the picture in a blob storage format only for as long as the app is open. I need it to be in a binary/base 64 format. So then, how can I convert a picture/file in Power Apps to the right format that is required in F&O?

Best,

Cathrine

Categories:

Connecting to Data

All responses (2)

Answers (0)

CathrineB 39 on 13 Feb 2020 at 12:25:26

Like (0)

Report
Re: Expense report receipts from Powerapps to Dynamics 365 Finance and Operations

Hi,

Thank you for your response.
Yes, the user should be able to update records in Finance and Operations with pictures using the "Add picture" control.

I cant seem to save the picture from the "add picture" media control seeing that the error message persists, saying that it cant convert the picture from the collection to "edm.binary".
ClearCollect(ColPhoto,{data:UploadedImage2.Image})

Do you know how I can ensure that the picture added is binary?

Thanks,

Merknad 2020-02-1...
v-yutliu-msft on 13 Feb 2020 at 02:24:13

Like (0)

Report
Re: Expense report receipts from Powerapps to Dynamics 365 Finance and Operations

Hi @CathrineB ,

Do you want to update images to Dynamics 365 Finance and Operations?

Could you tell me where do the images data come from?

1)If it is taken by camera control, the data will be save as binary.

You could use "camera name.Photo" to represent the captured pictures.

You could also save the captured pictures in a collection to use.

Collect(pic,{data:camera name.Photo})

2)If it comes from local by using Add Picture control, the images could be saved in collection as binary too.

You could also save the adding pictures in a collection to use.

Collect(pic,{data:UploadedImage1.Image})

What's more, if you want to the collection stored image binary data when you open the app, I'm afraid it's not supported.

You need to act action like "choose images" in add picture control or "take picture" in camera control, then the image data will be saved in powerapps.

Just opening the app is not enough.

After you save the images as binary, you could use flow to update data.

Here's a similar issue for your reference:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Uploading-Image-to-Dynamics-365-through-PowerApps-Microsoft-Flow/td-p/182767

Best regards,