Unanswered

SharePoint connector - formatting of generic 'Item' field

(0) Share

Report

Posted on by JohnnyB

I am trying to update SharePoint file properties through the standard connector. There are multiple document libraries where the file may reside and this is selected via a variable value.

The file properties are therefore not displayed and instead there is a single 'Item' field. However I am not sure how to format the fields to be updated.

Can someone advise the correct format to use?

Screenshot 2023-02-24 at 12.26.03.png

The above format results in the following error: The 'inputs.parameters' of workflow operation 'Update_file_properties' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'table'

The Microsoft documentation is not very helpful: https://learn.microsoft.com/en-us/connectors/sharepointonline/#update-file-properties

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@JohnnyB as you need to use dynamic library name, I would suggest to use REST API with Send HTTP Request to SharePoint as shown in example below:

In URI, replace 'test1' with your library name dynamic content, replace 1 with your File Item ID dynamic content.
Provide Header values as shown in screenshot
In body provide field values in following format:
{ 'Category':'Choice1', 'FieldName':'Field Value' }

Was this reply helpful? Yes No
JohnnyB 6 on at

Like (0)

Report

Thanks @annajhaveri for the suggestion.
It seems a little complex to use the SharePoint API to do this when there is a built in connector which should work (if only I knew how!)
I have tried your method as detailed above however it does not change the value. Can you see where I am going wrong?
The http call completes successfully and returns this:
And the flow is configured like this:
No errors, just doesn't work.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@JohnnyB in the body parameter you need to put in your field name and field value as shown in example below
{ 'Emailed_x0020_to_x0020_recipient':'Yes' }

Was this reply helpful? Yes No