Answered

Setting value for DropDown in EditForm

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I've a SharePoint List which is customized with Powerapps, the form contains 3 drop downs(Region,Country,BusinessFuncion) Region and Country are cascade dropdowns and all three fields are lookup fields in list. They are working fine while creating a new item but when Admin tries to edit a specific record details the values are not getting binded properly I'm using the below formula in Default property of Region dropdown(formula is Similar for Country,BFunction),

If(SMEMentorForm.Mode=FormMode.Edit Or SMEMentorForm.Mode=FormMode.View,First(Filter('Source',ID=Value(txtID.Text))).Region.Value)

When Admin edits the list item after refreshing the page for very first time, the first record values in list are getting binded to Region,Country,BFunction irrespective of the ID value other fields are working fine.and again when Admin tries for second time proper values are getting binded to dropdowns.

Not able to understand Powerapps behaviour here.

Any help would be appreciated!

Thanks,

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

R3dKap 1,594 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,
Could you please share with us how you set up the Items properties of your DataCardValue controls for your 3 drop-downs Region, Country and Business Function ?
Emmanuel
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Emmanuel,

I've set the Items property of BusinessFunction dropdown to SortByColumns(BusinessFunction,"Title",Ascending), Similar to Region from RegionList and for Country.

Thanks,
Satish
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All,

I got the form working as expected I changed the formula to below one,

If(SMEMentorForm.Mode=FormMode.Edit Or SMEMentorForm.Mode=FormMode.View,LookUp('Source',txtID.Text in ID).Region.Value)

Thought it might helpful for others! Have a great day guys:)

Thanks,
SB