Hero Image
Blog series - Conclusion

Conclusion So, there are a lot of HTTP calls that can be done. I’ve touched upon a few, hopefully you’ve gained a bit more insight in how these work. Some takeaways If you do a lot of HTTP calls in a single flow, there might be a cache issue poking around, resulting in double updates. When you use Term Store values to update, it wont show in the version history. (work around is to append them to a multiple line text field, but this results in a double entry in version history)

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - Get term store (for content types)?

Scenario: Fetching Terms from a Specific Term Set in a Term Store Objective You want to retrieve all terms from a specific term set within a term store in SharePoint. The term store and term set are identified by their unique GUIDs. Steps: Identify the Term Store and Term Set GUIDs You have a SharePoint site with managed metadata, and you need to fetch all terms from a specific term set. For example, all labels from the Status metadata column.

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Best practises

Best practises Here are some best practises I found either online or discovered myself. Use the Appropriate HTTP Method Use GET for retrieving data, POST for creating new resources, PUT for updating existing resources, and DELETE for removing resources. Set Proper Permissions Ensure that you have the necessary permissions for the operations you intend to perform. This includes configuring the appropriate access levels for users and applications. Proper permissions help prevent unauthorized access and maintain data security.

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Call a flow from a button

JSON formatting on a sharepoint list? In this blog post, we’ll explore the powerful capabilities of JSON list formatting in SharePoint. JSON formatting allows you to customize the appearance of your lists and libraries, making them more user-friendly and visually appealing. We’ll cover how to get a flow identifier, add a column, set JSON formatting code, and additional button formatting options such as showing/hiding based on fields and permissions. Get Flow Identifier To begin, you’ll need to get the flow identifier for the specific flow you want to use. This identifier is essential for linking your JSON formatting to the flow. You can find the flow identifier in the URL of your flow in Power Automate. Simply navigate to your flow, and copy the identifier from the URL. Or click on Export, Get flow identifier.

Thursday, February 20, 2025 | 3 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Fetching Specific List Information

Scenario Fetching Specific List Information Objective You want to retrieve the ID and Title of a specific SharePoint list whose title matches a given name. Steps: Identify the List Title: You have a SharePoint site with multiple lists, and you need to fetch the ID and Title of a list named ’name’ or of course add your own name. Construct the HTTP Request: You can filter on the name, by adding a ?$filter=title to your query. This uses oData filtering. You can filter on other things as well, you can use basic filtering such as lt (less than) le (less than or equal) gt (greater then) ge (greater or equal) eq (equal) or ne(not equal). Also, `Startswith, substringof, and date time functions are supported.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Free vs Premium?

Short overview - when to need a premium license and when not When can you get away with Power Automate free, and when do you need premium when working with http calls? Feature Free Premium Sharepoint HTTP request X Triggers X For a selected item x For a selected file X When an HTTP request is received X HTTP request X

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Get - Http get library id by GUID?

Scenario Fetching a Specific List by Library ID Objective You want to retrieve the details of a specific SharePoint list using its unique Library ID stored in a variable. Steps Identify the Library ID You have a SharePoint site with multiple lists, and you need to fetch the details of a list using its unique Library ID. The Library ID is stored in the variable VarLibraryID. Construct the HTTP Request Use the SharePoint REST API to get the list details by specifying the Library ID in the URL.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Get - Http get version number

Scenario Fetching a Specific Item from a SharePoint List Objective Get a specific item from sharepoint, with all the metadata, that you can then re-use in your flow. In my example we’re going with version number. Steps: Identify the List and Item: You have a SharePoint site with multiple lists, and you need to fetch the details of a specific item from a list. The list name and item ID are stored in variables VarListname and VarItemID but you can of course use your own naming method.

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Permissions

Permissions needed During my testing, I had SharePoint administrator access with full control on the lists, so I could do anything. For most of the calls, I recommend getting SharePoint administrator access to avoid any issues. Known Error: If the API call throws an error indicating that you’re not authorized, it doesn’t always mean you don’t have the correct permissions. It could mean you’re attempting to make an API call to an area of SharePoint that’s not allowed to be called. For example, if you’ve made a typo somewhere or aren’t using the correct type of call.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Types in Sharepoint

Using the SharePoint REST API to Update Metadata Fields When working with SharePoint REST API, you might need to update a metadata field that originates from a content type. To do this, you first need to get the type value from your library. This type value is essential for making the correct HTTP call to update the metadata field. I dont fully understand the inner workings of sharepoint, but without this field being accurate your call wont work.

Thursday, February 20, 2025 | 4 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Why do I need X-request-digest?

What is it, and why do I need it? Think of it as a type of token, that allows you, or permits you, to modify files on Sharepoint through an HTTP request. When you use POST as your method, and need to use Merge in your header, you also need to include a request digest value. Without it, you’re not authorized to do this action. What it will look like to use it in a call;

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Working with folders

Working with folders and the Sharepoint API When working with the SharePoint API, handling folders can sometimes be tricky, especially when dealing with deeply nested structures. In this post, we’ll explore how to dynamically grab the file location regardless of how deep it is in the root or folder structure. We’ll also cover how to handle common issues like permission errors. Dynamically Grabbing the File Location To work with folders in the SharePoint API, you need to use the full path. This ensures that you can dynamically grab the file location, no matter how deep it is within the root or folder structure.

Thursday, February 20, 2025 | 2 minutes Read