Answered

Send an HTTP request to Sharepoint

(0) Share

Report

Posted on by apenyaranda1985

Hello,

Can you help me?? I don't know why the following fails. I want to create a sharepoint list, so far so good, it fails me when making the field visible.

I get the following error:

{

"status": 400,

"message": "La vista especificada no es válida.\r\nclientRequestId: 9f49943b-a107-4de0-a9b5-de42f8bb67f6\r\nserviceRequestId: db40aca0-c005-6000-8d58-574e319b72f4",

"source": "https://golmarsistemas.sharepoint.com/sites/IT/_api/web/lists/getByTitle('lista_basica_3')/views/getbytitle('All%20Items')/ViewFields/AddViewField('email')",

"errors": [

"-2147024809",

"System.ArgumentException"

]

}

The process I follow is:

I think list.

I create field:

I make the field visible (this is where it fails)

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @apenyaranda1985,

Can you try and use the strField property in the body of the request with the email value and remove it from the URI?

Try something like below

URI

_api/web/lists/getByTitle('@{variables('ListName')}')/Views/getbytitle('@{variables('ViewName')}')/ViewFields/addViewField

Headers

{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" }

Body

{ "strField": "email" }

If it is still doesn't work can you also try it with the ViewId instead of the getbytitle('ViewName') method? I have an example blog for that approach type:

https://www.expiscornovus.com/2022/12/31/add-a-field-to-a-view/

Was this reply helpful? Yes No
Verified answer

apenyaranda1985 62 on at

Like (0)

Report
It already worked for me. The problem she had was that she had put in English:

getbytitle('All Items')

and I should put it in Spanish:

getbytitle('Todos%20los%20elementos')

On the other hand,
When fixing that point it has worked for me up to the point of adding items, and it adds everything correctly except a field that I have as a date
json code:

{ '__metadata': {'type':'SP.Field'}, 'FieldTypeKind':4, 'Title':'Fecha Registro' }

Mistake:

{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"es-ES","value":"JSON no v\u00e1lido. Se encontr\u00f3 una coma inesperada en el \u00e1mbito 'Object'. Una coma solo es v\u00e1lida entre propiedades de un objeto o entre elementos de una matriz."}}} clientRequestId: f81e9d8f-6138-4f69-bc3a-399807959b90 serviceRequestId: aba0aca0-0080-6000-7882-8d0531d5b641

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Dennis,
I am practicing the power automate. I have one usecase for collect meeting attendance from teams using power automate. So I seen your document in website. Your document you give the step clearly. But I have one doubt.I get one HTTP Action Error.I can't solve the error. Can you please help me to solve the issue. a clarification This flow of yours and I create it the same flow. But I am getting ERROR in HTTP ACTION of this flow how to fix them. and How to I getSuccessful implementation of FLOW.I Request you to see my Error and Please solve it.

Was this reply helpful? Yes No