Hi @tanthiamhuat88 ,
Here is an example of solution that can solve your problem.
For this example, I'm working with this Excel table:
To simulate your API calls, I'm creating two variables for each of the cryptos, containing an ID, a date/time timestamp and a price:
After that, you will be working with only one loop. I chose to loop the priceA array, but you can map any of the arrays returned by Yahoo Finance. Inside the loop, add a "Filter array" action, using the API response from the other crypto (in my case, priceB array) as input:
For the "Filter array" condition, set:
- For the left side, this expression: item()['DateTime'] - make sure to change "DateTime" for the name of the actual date property
- For the center dropdown, set as "is equal to"
- For the right side, this expression: items('Apply_to_each_-_PriceA')['DateTime'] - make sure to change "DateTime" for the name of the actual date property, and the Apply_to_each_-_PriceA for your actual loop name.
After that, you can use the "Add a row into a table" action:
To populate it, I'm using the following expressions:
- For DateTime (highlighted in yellow): item()['DateTime'] - make sure to change "DateTime" for the name of the actual date property
- For PriceA (highlighted in green): item()['price'] - make sure to change "price" for the name of the actual price property
- For PriceB (highlighted in blue): body('Filter_array')?[0]?['price'] - make sure to change "price" for the name of the actual price property
After running the flow, this is the final result in the Excel table:
Let me know if it works for you!
