Unanswered

How can I patch captured photo to image field in Microsoft Dataverse table?

(0) Share

Report

Posted on by Rena_Yu

I have a Dataverse Table named "Expenses". There's a "ReceiptImage" image type field.

I have a Camera Control, and a button to save the image to collection named "CapturedPhotos". See the collection structure below

How can I use patch function to add all photos to the dataverse table?

The current formula I am trying to use : Patch(Expenses,First(Filter(Expenses,ExpenseID=PerExpensesGallery.Selected.ExpenseID)),{ReceiptImage:Capturedphotos.Photo})

But the part in red above gives me error.

What's the correct way to achieve this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (1)

Report
Hello, @Rena_Yu, Try this

Patch(Expenses,First(Filter(Expenses,ExpenseID=PerExpensesGallery.Selected.ExpenseID)),{ReceiptImage:{Full:Capturedphotos.Photo,Value:Capturedphotos.Photo}})

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com

Was this reply helpful? Yes No
Rena_Yu 9 on at

Like (0)

Report

Hi Ahmed,

Really appreciate your reply. I tried that but get the error below. It seems the formula recognize my Capturedphotos.Photo as a table but not a record?

Thanks,
Rena

Was this reply helpful? Yes No
Rena_Yu 9 on at

Like (0)

Report

I find a blog describing the possible cause: https://powerapps.microsoft.com/en-us/blog/public-preview-of-multiple-image-attributes-in-power-apps/#:~:text=If%20there%20are%20multiple%20fields%20with%20the%20image,with%20a%20Image%20data%20type%20in%20Power%20Apps

"it only allows a single image when used with an Image data type field. If you want multiple images per record, use either the attachment feature or create a separate table and then create a N – 1 relationship."

Currently, it can work if I use Camera1.Photo and Camera1.Stream. Maybe we should find a solution mentioned in this blog.

Thanks,
Rena

Was this reply helpful? Yes No