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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
unislacker 82 on at

Like (0)

Report

Thanks

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

Was this reply helpful? Yes No
Sunidhigambhir1 77 on at

Like (0)

Report

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.

Was this reply helpful? Yes No