SharePoint / Microsoft Flow – Maintain List details for no-code developers

This post is part of my User guide to using the SharePoint REST API in Microsoft Flow for no-code developers series.

I will look at the following operations on a list in this post.

  • Create a list
  • Get the list details.
  • Update lists details
  • Delete a list

Getting the list details is easy using the Send an HTTP request to SharePoint  action. Simply select the Site Address and supply the API uri then supply the body details and a SharePoint coder would be quite happy to create all of this within less than no time. I have found however that no-code developers struggle sometimes.

To make this easy for no-coders, I’m going to start by setting some variables.

  • ListName
  • ListDescription

SharePoint / Microsoft Flow – Maintain List details for no-code developers 1

Create a list

Now I can create a list using my 2 variables:

SharePoint / Microsoft Flow – Maintain List details for no-code developers 2

Looking at my flow run history, my list is created:

SharePoint / Microsoft Flow – Maintain List details for no-code developers 3

Get a list

Getting the list details of the list that we just created is now just as easy as shown below:

SharePoint / Microsoft Flow – Maintain List details for no-code developers 4

Now to get for example the title of the list (I agree why would you want to get the title of a list if you know the title of the list), use something like the following expression in an initialize varibale or compose action:

body(‘Send_an_HTTP_request_to_SharePoint’)?[‘d’]?[‘Title’]

SharePoint / Microsoft Flow – Maintain List details for no-code developers 5

Update a list

To update an existing list we need to do the similar things as when we create a list. In the headers use X-HTTP-Method and set it to MERGE.

SharePoint / Microsoft Flow – Maintain List details for no-code developers 6


Delete a list

To delete the list we just need to supply the API Uri. In the headers use X-HTTP-Method and set it to DELETE.

SharePoint / Microsoft Flow – Maintain List details for no-code developers 7

2 thoughts on “SharePoint / Microsoft Flow – Maintain List details for no-code developers

  1. commented on October 31, 2019 by Feibien

    Hi,
    I have a question, have you tried to create a field in a list/library and set in default view using flow and rest api?
    I manage to create the field but I haven’t found a way to set that field in default view. I posted the question in flow forum: https://powerusers.microsoft.com/t5/Building-Flows/create-new-choice-column-to-sharepoint-library-using-flow/m-p/393981#M44885
    Thanks beforehand for any help/tip

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: