Answered

BUG: Last update made image column in sharepoint list read-only and broke Patch() function in my app

(0) Share

Report

Posted on by bigFin

In my PowerApp, I use a Patch() to update a SharePoint list image column (formatted as picture) with the last submitted attachment URL. This was working until recently. Now, when I submit my form (and the patch executes onSuccess), I receive the error that this column is read-only. This issue broke my patch function, so my SP list now contains a ton of rows with missing data from the last week (all prior form submissions contain patched info).

My Patch() code is below. What happened? Any advise on how to fix this?

Patch(list, 
 {ID: form.LastSubmit.ID},
 {Image_link: First(form.LastSubmit.Attachments).AbsoluteUri}
);

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-yutliu-msft on at

Like (1)

Report
Hi @bigFin ,

Do you mean that you can not update Image_link column?

Could you tell me what is your Image_link column data type?

Please notice that picture data type is read only in powerapps.

You need to set Image_link to hyperlink data type.

I've made a similar test but not met any problem.

Here's my test:

My form's OnSuccess:

Patch(list3, {ID: Form1.LastSubmit.ID}, {'Link to item(form)': First(Form1.LastSubmit.Attachments).AbsoluteUri} )

'Link to item(form)' field is my hyperlink field:

And I could update successfully to this field.

Best regards,

Was this reply helpful? Yes No
bigFin 25 on at

Like (0)

Report

The image_link column is formatted as a picture, not a hyperlink. I prefer this as the image_link column displays a thumbnail on the SharePoint list.

Can you suggest a workaround for this functionality?

I see that I cannot make the image column as a calculated field. Maybe I can make a flow to update an image (picture formatted) column with the URL of the first item from the attachment field?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (1)

Report

Hi @bigFin ,

1/Picture type is read-only in powerapps and flow. This is connector's limit.

I'm afraid there's no workaround about this.

Please refer this doc to see sharepoint data type in powerapps:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online

You could only update Picture type in sharepoint list manually.

2/Maybe you could consider create a sharepoint custom form.

You could insert an Image control in this form, set this Image conrol's image property to :

ThisItem.hydlinkcolumn

Then the image control could display the iamge.

Best reagrds,

Was this reply helpful? Yes No
bigFin 25 on at

Like (1)

Report

This is a frustrating limitation, especially since this approach has been working for me for several months without any issues. My team really likes the thumbnails as it helps them quickly identify items in the list. It's a shame that my only available option is to rebuild my SharePoint list views as a custom form to achieve what was previously working natively.

Was this reply helpful? Yes No
nikki87 3 on at

Like (0)

Report
this is super old but i just encountered this and wanted to share. @v-yutliu-msft is right - Patch() and therefore SubmitForm() will not work if you're trying to use a SP column with datatype hyperlink - picture, and it will only work if its datatype is hyperlink - hyperlink. however, it's still possible to brute force your SP list into showing the hyperlink - hyperlink column as a thumbnail image using custom JSON formatting.
Paste this into the JSON column formatting for your hyperlink - hyperlink column:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "attributes": { "href": "@currentField", "target": "_blank" }, "children": [{ "elmType": "img", "style": { "width": "100px" }, "attributes": { "src": "@currentField" } }] }

Was this reply helpful? Yes No