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

Best approach to Build "Update Client Info" App


I'd like to know want is the best approach to build an update client info app, and want to be clear before start coding...

ClientList: (ClientID, Name, Address, Province, City, Phone, Notes)  // This is the old data to be updated.
Problem: The client adresses and other fields weren't accurate. The field City was not dependent. It´s like to say that Miami is on California.

My thought was to create 2 more sharepoint list like: 
ClientListUpdated: (ClientID, Name, Address, Province, City, Sector, Geolocation, Image1, Image2, Image3, Phone, Notes)

LocationList: Province, City, Sector (All dependents by dropdown)

The process: a user has to visit the client and update the location info and fill others fields like Location, Geolocation, Image1, Image2,Image3, phone2, phone3, notes, and others.

Is this the best approach? or can i update just the ClientList and add those fields in there?
Also have control of what Clients have been updated.

Thanx in advance!



Community Support
Community Support

Hi @joeljohn ,


Could you elaborate your requirements?

Do you want to cascade provinces and cities? for example, when you select a state/province, only show the corresponding cities, right?


If my understanding is correct, it is a good idea to save all provinces and cities to a standalone list, it can be much easier to create cascading dropdown.



Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,523)