Unanswered

PATCH method for http request to share point failing due to URI

(0) Share

Report

Posted on by swami12345

I have a powerapp, from there i construct a json that include captured image and metadata about the image. My SharePoint has document library, one of my powerapp flow create a folder whenever, a new list item is created. current flow takes the json object and folder name and save the images to the folder. My issue is, after file creation, i want to update the fields/columns related to the captured image. I need help for Uri for http request.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @swami12345,

I see you are using ListItemAllFields in your URI. My suggestion would be to use the ValidateUpdateListItem method instead.

Below is an example for a single field, but the formValues array also allows multiple fields at once:

https://tomriha.com/update-single-sharepoint-column-in-power-automate-with-http-request/

Was this reply helpful? Yes No
swami12345 20 on at

Like (0)

Report

hi @Expiscornovus
i think list "_api/web/lists" will not work with me. I have folders in image library, and within the folder, i have images stored. Can you suggest any approach
also "form values" is for list, does the data inside the folder is considered as list

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @swami12345,

A folder or file also has an item id (in your case if your creating the folder you should get the id returned in the outputs). So you should also be able to use that method for files and folders as well.

I have used this method before file metadata property updates. Do you want me to share an example for an Image Library folder?

Was this reply helpful? Yes No
swami12345 20 on at

Like (0)

Report

@Expiscornovus , it will be very helpful if you share the image. Thank you

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @swami12345,

Below is an example

The URI uses the ItemId of the Create File action. That should be the ID of the image your are trying to update.

URI

_api/web/lists/GetByTitle('Image Library')/items(@{outputs('Create_file')?['body/ItemId']})/validateUpdateListItem

Body

{ "formValues":[ { "FieldName": "Element_ID", "FieldValue": "Power Automate Ftw" }, { "FieldName": "Floor_Number", "FieldValue": "13" } ] }

Was this reply helpful? Yes No