Thanks for your guidance. I have a similar form and struggling with a query related to a Date field. Like the Country field, suppose I want to display a date field value from another Sharepoint List , what code should I use. If I use the same Distinct and Filter criteria the Date value is represented as a number string and not a dd/mm/yyyy date value. Please help.
Hi Santhosh, Region also should set the default value. Please make sure to set "DefaultSelectedItems" property of the Region dropdown to LookUp(Distinct(DataSource, Region).Result,Result=ThisItem.Region). I just verified and it works. Let me know if still an issue.
How condescending you are! Someone's taking the effort the help people out, and this is the way to respond? If you aren't mentioning the accent, what do you mean by "im not even mentioning your accent yet" ? Have some courtesy!