Workaround for change affecting Patch of Camera.Image to SQL

(3) Share

Report

Posted on by BrianHFASPS

718

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
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!

Was this reply helpful? Yes No
BrianHFASPS 718 on at

Like (0)

Report

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.

Was this reply helpful? Yes No