Skip to main content
Community site session details

Community site session details

Session Id : maceggMXXaUtWp7heskHZL
Power Automate - Building Flows
Answered

Send an HTTP request to Sharepoint

Like (0) ShareShare
ReportReport
Posted on 24 Apr 2023 06:29:23 by 62

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.

 

apenyaranda1985_0-1682317670623.png

 

I create field:

 

apenyaranda1985_1-1682317670626.png

 

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

 

apenyaranda1985_2-1682317670628.png

 

Thank you

  • Community Power Platform Member Profile Picture
    on 26 Apr 2023 at 06:30:30
    Re: Send an HTTP request to Sharepoint

    Screenshot 2023-04-24 125144.png

    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.

  • Verified answer
    apenyaranda1985 Profile Picture
    62 on 25 Apr 2023 at 10:33:19
    Re: Send an HTTP request to Sharepoint

    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

     

  • Expiscornovus Profile Picture
    32,159 Most Valuable Professional on 25 Apr 2023 at 08:11:01
    Re: Send an HTTP request to Sharepoint

    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"
    }

     

    strfield_property.png

     

    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/

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete