Workaround for change affecting Patch of Camera.Image to SQL

(2) Share

Report

Posted on by BrianHFASPS

697

Back in July I posted this question - Storing photo format changed? Camera control to Azure SQL works on web player not on IOS player that got no responses. Just in case anyone else comes up with same problem I wanted to share a workaround I found today.

The code I have been using for years was:

Patch(
            '[dbo].[Daily Activity Attendance]',
            Defaults('[dbo].[Daily Activity Attendance]'),
            {
                SigninPhoto: Camera.Photo, //Typo in original post was .Image
            }
        )

After an update to Power Apps release in late June this started uploading a link to a jpeg rather than actual data:

I couldn't find a fix and contacted Microsoft support and am still going back and forth with them. Today I came up with this work around. On the Camera control I did this:

Then in my patch statement I am doing this instead:

Patch(
            '[dbo].[Daily Activity Attendance]',
            Defaults('[dbo].[Daily Activity Attendance]'),
            {
                SigninPhoto: PhotoVar,
            }
        )

This is again giving me data:image instead of /SessionStorage/...jpeg.

Categories:

General Questions

Connecting to Data

All responses (3)

Answers (0)

BrianHFASPS 697 on at

Like (0)

Report

Workaround for change affecting Patch of Camera.Image to SQL

Reply to Nandit - That was a typo on my part, it should have been .Photo instead of .Image. .Image isn't a valid statement. It was working with .Photo for years until an update to the PowerApps platform in I believe June 2024. When the data gets passed to SQL via the Patch the problem happens. The problem only happens with the IOS / Android players not with the Web Player or in Edit mode for PowerApps.
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Workaround for change affecting Patch of Camera.Image to SQL

Hi ,

Can you please try replacing your Camera.Image with the following:

Camera.Photo

I added a camera control to the screen and the following code on the OnSelect:

ClearCollect( colImage, {SigninPhoto: Camera.Photo} )

I get the following data when I add the collected value to a Text label:

If this is what you are after, I hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
Michael E. Gernaey 40,272 Super User 2025 Season 1 on at

Like (0)

Report

Workaround for change affecting Patch of Camera.Image to SQL

Thank you for sharing what you did. Its a shame when support takes, hours, days, weeks or never helps resolve it, bug or not in the platform. We all share your frustration.