Save Data to SharePoint List from an External System API using Power Automate

This video will walk through the process of how to save data to the SharePoint list from an External API using Microsoft Power Automate flow. In this example, I have taken an open-source public API data to process to SharePoint List. I will be using HTTP action of Power automate. Please note this is a premium action in power automate and the user creating the flow will need Power Automate plan to use HTTP action in Power automate to retrieve external system API data.
Support us with your Amazon purchases, click here: amzn.to/3e6ZrSM
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 01:02 Create SharePoint List to Store API Data
• 02:02 Build flow using Power Automate
• 02:18 Configure Http action in Flow to Reterive API Data
• 04:09 Configure Create Item in SharePoint List Flow Action
• 05:16 Test Power Automate Flow to Retrieve API Data
• 06:26 Outro & Subscribe
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerApps
#SharePoint
#FetchData

[@sudhirsimson3340]

Thanks for sharing. Do we have alternate option if we dont have Premium capacity. I am looking to use API call to get Item history details of a Sharepoint List. Any suggestions for that? Thank you

[@Almazees]

Awsome!

[@KeaPointTechTips]

Thanks!

[@seanjoiner8138]

Hello, That's for that. I do have a question about requesting real-time alerts from an API. Would that be processed the same way?

[@KeaPointTechTips]

In your case the trigger is an alert. Explore how you can use external alert as a trigger.

[@pthapa55]

Hello, I am confused. How do I create a flow to run more than 5000 rows in SharePoint list? Can you please share some lights to it. Thank you.

[@KeaPointTechTips]

You should use azure automate job and create/run PowerShell script there to execute operation on large lists.

[@trg1896]

What to do if I don't see the columns in the API? How to create the list in this situation?

[@KeaPointTechTips]

API should expose the columns which you need to create list.

[@AnuragNayak-up5eu]

hello how can i push data from oracle database and store it into sharepoint list?? Please respond its urgent

[@KeaPointTechTips]

You need oracle on prem data gateway installed. only then you can get data form oracle to M365 services.

[@cleitonalves2875]

Is it possible to save data to a SharePoint list using Android mobile?

[@KeaPointTechTips]

what is the data source?

[@cleitonalves2875]

@@KeaPointTechTips picture and strings

[@aashritsrhymeandactivities4911]

Nice information but video is blurry.

[@KeaPointTechTips]

HI, Thanks for your feedback. I have checked my video and it is not blurry at all. What happens is, if you are at low-speed internet, RUclips auto select the quality of the video to low pixel. Make sure you set the right quality for your youtube video.

[@aashritsrhymeandactivities4911]

@@KeaPointTechTips Thanks for your information.