Unanswered

Convert country to ISO

(0) Share

Report

Posted on by Community Power Pla...

Is there a way I can get someones ISO code from their email? I want the default of one of my searches to be by the persons ISO country code. If I use Office365Users.UserProfileV2(User().Email).country it will give the entire name. Is there a way I can convert this to ISO?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Hi @Anonymous

You can download the Excel file from https://datahub.io/core/country-list , convert it to a table and connect it to your app with the Excel static connector. Then you can use a lookup() to that table.

Lookup(Table1,Name=Office365Users.UserProfileV2(User().Email).country,Code)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It says the function lookup has invalid arguments

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It just says false

Was this reply helpful? Yes No
FelixK 36 on at

Like (1)

Report

I had a similar issue in a HTTP GET providing me ISO3 country code and I needed to pass this to a HTTP PUT endpoint expecting a ISO2 country code. Example "DEU" -> "DE".
My Solution:

- Compose element with an json array of all countries [{"ISO3":"DEU", "ISO2":"DE"}, {250 more countries}..]
- Filter this array with your needed country code as a filter criteria
- The filter result is your needed ISO2 country value

Attached my converter flow.

ISO3toISO2Country...

Was this reply helpful? Yes No