cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Lingualizer
Level: Powered On

How to create a collection with data from user defined connector?

Hi there,

I created a user defined connector to retrieve exchange rates (fixer.io).

The connector works fine and displays the results:

{
"base": "EUR",
"date": "2018-03-19",
"rates": {
"AUD": 1.5994,
"BGN": 1.9558,
"BRL": 4.0567,
...

"ZAR": 14.892
}
}

 

How to create a collection to store the country codes and the corresponding rates?

I'm always struggeling with the syntax

Thank you!

4 REPLIES 4
Community Support Team
Community Support Team

Re: How to create a collection with data from user defined connector?

Hi @Lingualizer,

 

May I know where did you results displayed? In a Gallery?

 

To create a collection, you need to use the Collect function. The formula should be something like:

 

Collect( CollectionName, { CountryCode: countrycode!Text, Rates: rates!Text}  )

 

For your reference:

https://docs.microsoft.com/en-us/powerapps/create-update-collection

https://docs.microsoft.com/en-us/powerapps/functions/function-clear-collect-clearcollect

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lingualizer
Level: Powered On

Re: How to create a collection with data from user defined connector?

Hi Mona,

Thanks for your reply.

Creating a Collection is the first part.

How would I populate the Collection with CountryCodes and Rates?

I am not sure where to add the "Fixer.GetExchangeRates" command.

I guess this is where the data comes from?

Cheers

//Peter

Lingualizer
Level: Powered On

Re: How to create a collection with data from user defined connector?

Hi there,

Any suggestions how to create a Collection with the retrieved data of the connector?

I know how to build a Collection, but I don't know how to use the outcome of the Connector.

Thanks!

LarryJaxn
Level: Powered On

Re: How to create a collection with data from user defined connector?

Trying to do the same thing with the IcM connector.  I want to do a search and store the results in a collector.