Unanswered

Update SharePoint folder column value from SP Column email address

(0) Share

Report

Posted on by sunil_stryker

Hi,

I have created a flow to create a folder when a new item is created in the SP list by taking some of the value from the List Item.

There is a custom column added in a folder for email id, which needs to copy from the SP list to the folder column.

My current flow is working fine but not updating the column value in the folder library.

Currently, it's updating the folder path column but not updating the email id column added an image for reference.

Can someone help me how to copy the email from the SP list to the library column, please?

Thanks

Categories:

General topics

All responses (14)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@sunil_stryker ,

I don't think you can use Update File Properties to update folder metadata. File is an object whereas folder is a location.
Try Update Item property instead.
Solved: Update a folder in shared documents metadata on a ... - Power Platform Community (microsoft.com)
sunil_stryker 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ , @annajhaveri

Thanks for your support,

I have updated the flow y using folder metadata Send an HTTP request to SharePoint.

but flow showing an error and not updating the folder column.

Added some snaps for reference, can you please provide me a few screen shout your suggestion?

Thanks
Sunil
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

This is not the correct ID field. It should be the item Id of the folder, whereas you seem to be passing a text.
sunil_stryker 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ ,

Thanks for your suggestion, even after updating the itemsId flow not working and showing an error (attached).
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

There are two underscores before metadata
__metadata
sunil_stryker 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ,

this looks like 2 underscores but actually, we have only one underscores before metadata.

still, it's getting an error and failing the flow, do we have any other option to update the value for the document library using the SP list item...?

Added some snaps for reference.
sunil_stryker 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ

Even though I tried to by adding 2 underscores, still, the flow getting failed.
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Sunil,

What I meant was that SP REST Schema expects two underscores, whereas you have provided just one.
Sample below:
{ '__metadata': { 'type': 'SP.List' },
'AllowContentTypes': true,
'BaseTemplate': 100,
'ContentTypesEnabled': true,
'Description':
'My list description',
'Title': 'Test' }
sunil_stryker 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ ,

Even after adding 2 underscore still the flow getting failed with below error.

The parameter __metadata does not exist in method GetById.
clientRequestId: 7835439a-91dd-444e-913e-b76bd4d7efc2
serviceRequestId: cdd17fa0-30bb-2000-e817-afe215435be4
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Send me your REST endpoint and the body