cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bigFin
Frequent Visitor

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

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}
);

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

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:

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support
Community Support

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

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:

493.PNG

 

And I could update successfully to this field.

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bigFin
Frequent Visitor

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

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?

Community Support
Community Support

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

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:

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

bigFin
Frequent Visitor

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

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.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,868)