Creating a list in Sharepoint

(0) Share

Report

Posted on by Amaya2013

103

Hi guys,

I'm trying to create a list in sharepoint using http action in Power Automate, it saves down fine but when I run it then I get the error message. Please see below:

I've used the below values in HTTP action. Can anyone please help me to fix this? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Amaya2013,

This could be a case of a small typo. The error suggests that what you used in the Body is invalid json. Can you share the whole payload of the Body field?

Normally the payload should be something like the below. Can you make sure every line ends with a comma except the last one?

{ "AllowContentTypes": true, "BaseTemplate": 100, "ContentTypesEnabled": true, "Description": "My Lunch List", "Title": "Weekly Lunch" }

Also double check that in the headers the word nometadata is one word, not with a space in it.

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

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

Thanks @Expiscornovus - It worked 🙂 . Managed to create a new list in sharepoint using Power automate.
Just wondering how we can delete a list from sharepoint? Can you please help me with that? Thanks

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Amaya2013,

You can use another HTTP request for that. That would use the X-HTTP-Method with a DELETE value.

Below is an example

In this case I am using the getbytitle method to find the list based on the title. You can also use the guid using the lists(guid'{list_guid}') approach to find the matching list.

URI

_api/web/lists/getbytitle('@{variables('ListName')}')

Headers

{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose", "If-Match": "*", "X-HTTP-Method": "DELETE" }

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

@Expiscornovus - I'm getting an error message as below when trying to delete a list

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

Like (0)

Report

Hi @Amaya2013,

I see in the screenshot the Headers values are stored in the Body field. Can you use those in the Headers field instead and try again?

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

Yes it worked. Thanks for all your help 🙂

Was this reply helpful? Yes No