web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / CSV or API in Power Apps
Power Apps
Unanswered

CSV or API in Power Apps

(0) ShareShare
ReportReport
Posted on by 82

Hi All 

 

All day yesterday i worked on trying to get the below API into power apps with no luck, so any guidance would be awesome.

 

https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&outputsize=full&apikey=demo

 

I managed to create a flow that saved as CSV but looks like i cant use that file type, I know i could re-save in excel once downloaded but that defeats the point of automation. I also tried to make a custom connector but couldn't get it to work either 😞 

 

 

 

I have the same question (0)
  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @unislacker,

    Have you looked at Dataflows?  They are made to load data from external source into Power Apps (CDS) and perform your required transformation. More on Dataflows: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-and-use-dataflows

    Hope this helps! 

  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @unislacker ,

     

    Do you mean you want to pass the API data to PowerApps?

    Have you tried the Response action in the flow? It can return an array from Flow to PowerApps.

    Please refer to this blog:Return an Array from Flow to PowerApps (Response Method) 

    Hope this helps.

    Sik

     

     

  • unislacker Profile Picture
    82 on at

    Thanks

     

    I will give this a go and then come back to you cheers.

  • Sunidhigambhir1 Profile Picture
    77 on at

    Hello,

    API (Application Programming Interface) is a set of functions that allows applications
    to access data and interact with external software components, operating systems.
    To simplify, an API delivers a user response to a system and sends the system's response back to a user.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard