SharePoint API Power Automate - Learn to create cool stuff

The video provides a detailed walkthrough on using the SharePoint API with Power Automate to enhance capabilities beyond the built-in actions. The main tasks covered include creating a SharePoint site, adding a list, adding a column to that list, and creating a view, along with essential troubleshooting tips. Creating a SharePoint Site Overview: The process begins with creating a new instant cloud flow in Power Automate and adding an HTTP request action for SharePoint. Details: The video illustrates how to send an HTTP request to SharePoint to create a site using the SharePoint API. It highlights the importance of using the correct API endpoint, setting up the appropriate headers, and configuring the body of the request with necessary parameters like site name, URL, and template ID. Key Tools: Utilization of SharePoint HTTP action which handles authentication, avoiding the need for manual token management. Adding a List to the Site Setup: After creating the site, the next step is to add a list. This is done by sending another HTTP request. Execution: The tutorial guides on how to format the request to add a new list, explaining how to set up headers and the body with JSON configuration specifying the list details. Adding a Column to the List Procedure: Adding a column involves sending an HTTP request to the SharePoint API, specifying the list and the details of the new column. Configuration: The presenter details the body setup required for the JSON payload, which includes the column name, type, and additional settings. Creating a View Final Touch: The last part involves creating a custom view for the list using yet another HTTP request. Explanation: View creation is shown with specific parameters in the request body to define how the view should be set up and what columns it should display. Troubleshooting and Tips Debugging: Throughout the video, troubleshooting tips are provided, such as how to use the 'terminate' action to stop the flow intentionally for testing specific parts. Learning Resources: The video emphasizes learning by doing, suggesting viewers to experiment with the actions and adjust parameters as they go along. Conclusion The video concludes with a comprehensive review of the steps covered, encouraging viewers to explore further and utilize the SharePoint API with Power Automate to automate more complex tasks. Up your Power Apps Skills Today! https://www.powerapps911.com/up-your-power-apps-skills 0:00 SharePoint API Power Automate 0:40 Create a manually triggered flow 1:20 Send an HTTP request to SharePoint 1:55 Create a SharePoint site with Power Automate 10:58 Create a SharePoint list with Power Automate 16:35 Avoiding failure with Terminate 20:03 Create a SharePoint field with Power Automate 27:42 Add a SharePoint field to a view with Power automate Do you need some help with something that you are working on, contact us! https://www.powerapps911.com/contact PowerApps911 https://www.powerapps911.com/ Let's connect on social! Twitter: https://twitter.com/ShanesCows Facebook: https://www.facebook.com/powerapps911 Instagram: https://www.instagram.com/shaneyoung911/ LinkedIn: https://www.linkedin.com/in/cincyshane/ Join this channel to get access to perks: https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng/join #powerautomate #PowerPlatform #sharepoint #api