Unanswered

CSV or API in Power Apps

(0) Share

Report

Posted on by unislacker

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 😞

Categories:

Dataflows

All responses (4)

Answers (0)

Sunidhigambhir1 77 on at

Like (0)

Report

Re: CSV or API in Power Apps

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.
unislacker 82 on at

Like (0)

Report

Re: CSV or API in Power Apps

Thanks

I will give this a go and then come back to you cheers.
v-siky-msft on at

Like (0)

Report

Re: CSV or API in Power Apps

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
EricRegnier 8,714 Most Valuable Professional on at

Like (0)

Report

Re: CSV or API in Power Apps

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!