Expense report receipts from Powerapps to Dynamics 365 Finance and Operations

[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

[v-yutliu-msft]

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

Best regards,

[CathrineB]

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,