Announcements
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?
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)
It says the function lookup has invalid arguments
It just says false
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 valueAttached my converter flow.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 490
WarrenBelz 375 Most Valuable Professional
11manish 302
