Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

How to use Same Form Control as New, Edit and View Mode

Hello Team,


I'm having a Gallery Control(say GalCustomerDetails) to fetch data from SharePoint List (say CustomerDetails , CustomerMaster) .


Form Control Name - frmCustomerDetails

Combo Box 1(input Field) - CustomerID (ID's listed from CustomerMaster)


Combo Box 2(output field and always disabled) - This needs to pull Name from Customer Master in New Mode


On a button click I will have to save the form to CustomerDetails. I only have 1 form which should act in New, Edit and View Modes


I need to use 2 data source for Combo Box 2. ie, New Mode will have to fetch from CustomerMaster and Edit/View mode will have to fetch from CustomerDetails


Please help me on this!!


Thank you in advance!!

Super User
Super User


You can use the Coalesce() function to apply to the Items property of the combobox.

Coalesce(Parent.Default, somefunctionforfillingthecombobox)

Coalesce() evaluates its elements from the left to the right until one is found to contain data.  In the case of a new Form, Parent.Default will always be empty so it will evaluate your function for the item property.  When data is saved, Parent.Default will contain data and the Coalesce() function will stop there. 

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,998)