I have a topic including 2 questions:
1. What is your continent you're currently living in (using Continent entity).
2. What is the country you're currently living in (using Country entity).
I would like to add some sort of validation to make sure the country added does in fact belong to the continent entered so I won't have situations like 'Europe' and 'China'.
Before I go and develop a SQL SP that validate it, I was wondering if there's a quicker, built-in way / flow to achieve it?
Would appreciate any suggestion (and apologies for my many questions... I'm sure more will come 🙂).
Thanks,
Hi @HaimOz
Have you think about calling a Power Automate and pass the country and Continent. In Power Automate You should be able to check if the country belongs to the Continent and respond accordingly to BOT.
Regards,
Deepak
update:
One way I found was to create new entities, each one different continent (e.g. 'EMEA', 'APAC', etc.) and include values all all countries within that continent (will be a long list) so the user can type its own. If it doesn't appear in the entity, it'll ask again.
Happy to hear other ideas.