Skip to main content

Notifications

5 Common HTTP Hacks with SharePoint

Audrie101 Profile Picture Posted by Audrie101
Check out these typical actions that we don't have in our SharePoint connector yet, but you can do these actions using the "Send HTTP Request to SharePoint".
1. Create List on SharePoint 1:05
2. Create a Custom Column for the SharePoint List created 10:50
3. Edit Hyperlink Display Name 19:10
4. Put a Person into a SharePoint Group 26:20
5. Put a new Folder into a SharePoint Library 34:00
I hope it helps to have these together! Enjoy!
Audrie
 
 
 

 

Someone asked how to add multiple columns to a list - not a problem. Combining HTTP requests can require batch operations which can be tricky (see here), so I would actually suggest keeping it simple and just copying the add column action if you only have a couple of columns to add. If you don't like the idea of a step for every new column, try the batch method. I wanted to have some fun and use just 1 HTTP request without the batch method (more hacking fun-LOL), so I looped the HTTP request in the Flow you see below (this only works if you're using the same properties for each new column). The switch action is there to set the column properties based on the Loop Counter (that switch can have up to 12 columns comfortably IMO, but if you have more than 5 you'll probably want to reformat your JSON instead of taking the approaches I did in the video or below - or just use .ps).

 

My hack below doesn't require any change to the JSON, which is why I like it, because if I had my way I would never be playing around with JSON-LOL. The switch case sets the Name, Description, and Field Type based on what the LoopCounter is up to (I started the counter at 0). There are three columns added to the list here - 1 for each case (the list creation was the previous action above the screen shot).

 

loopHttpFun.PNG

 

 

 

 

 

 

 

 

 

 

Categories:

Comments