Answered

Default Field depending on other field not getting populated in New Mode

(0) Share

Report

Posted on by Lephas

Im struggling to understand why my field is not getting populated on a new sharepoint form:

#('Regions' is a separate List to control the assigment of Countries to Regions)
#Country Field
DefaultSelectedItems:
If(
 'Form_Certification_Process_Basic-Info'.Mode=FormMode.New;
 {
		Value: Office365Users.UserProfileV2(User().Email).country
	};
 Parent.Default
)
Items:
Filter(
 ('Regions');!IsBlank(Country)
).Country

#Region Field 
DefaultSelectedItems:
If(
 'Form_Certification_Process_Basic-Info'.Mode=FormMode.New;
 {
		Value: LookUp('Regions'; Country = Country_DataCardValue.Selected.Country;Region.Value)
	};
 Parent.Default
)
Items:
Choices([@'Regions'].Region)

So the country Field gets populated with the Country of the currently logged in User. This works as intended.
But somehow the Region Field stays empty when i start or reset the form. - however it has a value when I change or update the Country field (can be the same value). Can someone explain why? Do i have to add some sort of delay until my Country field is populated?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Lephas ,

Can you try below code and see if it works. I would recommend to store logged in user country to a global variable and use it across controls

// App On-start or screen on visible Set(UserCountry,Office365Users.UserProfileV2(User().Email).country);
// OnChange property of country dropdown Set(UserCountry, Country_DataCardValue.Selected.Country);

#('Regions' is a separate List to control the assigment of Countries to Regions) #Country Field DefaultSelectedItems: If( 'Form_Certification_Process_Basic-Info'.Mode=FormMode.New; { Value: UserCountry }; Parent.Default ) Items: Filter( ('Regions');!IsBlank(Country) ).Country #Region Field DefaultSelectedItems: If( 'Form_Certification_Process_Basic-Info'.Mode=FormMode.New; { Value: LookUp('Regions'; Country = UserCountry;Region.Value) }; Parent.Default ) Items: Choices([@'Regions'].Region)
Lephas 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot . While i did not use your exact code - your tipp about using variables helped me a lot. I stored those user information in a global variable and this way everything works as intended!