Answered

Field for 'Picture or Hyperlink' missing from Create New Item to SharePoint List.

(0) Share

Report

Posted on by anthonys123

483

Among several other fields, I'm noticing that the Picture or Hyperlink column in my SPO List is not present in the PowerAutomate actions Create Item or Update Item.

I've noticed that this column has the following formatting, not sure where this came from:

{"$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":"150px"},"attributes":{"src":"@currentField"}}]}

And I'm finding through the suggested similar posts there may be a way to do this with Rest API.

https://www.dmcinfo.com/latest-thinking/blog/id/9832/creating-sharepoint-list-items-in-microsoft-flow-using-a-rest-api

Before I delve too deep into this five year old solution (Wow! Literally to the day! "03/12/2019"), I want to confirm that it's not possible to update a Picture or Hyperlink value in a SharePoint List or if there may be an issue with the formatting in this column.

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately REST Api is the only available option if you are doing this via Power Automate
GREGWOUARE 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I litteraly faced the same issue 2 minutes ago

Thanks for the REST API solution. It's a shame 5 years later it is still impossible to do that ...
anthonys123 483 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the prompt clarification.
ayms 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually, I've found it is possible as long as in the List settings column properties you select 'URL' in the dropdown for 'Format URL as' (instead of as 'Picture'). Then once you've completed your Power Automate flow, go back into the column properties in List Settings and switch it back to Format as Picture.