cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Billy_C
Helper V
Helper V

Powerapps model driven apps set lookup field based on condition

Hi,

I have been making a powerapps model driven application which is our crm. So our company entity has 4 different locations, 1 for headquarters, 1 for invoices, 1 for delivery, and a list of all locations. The location entity has an multi select option set with 5 different settings, headquarters, invoices, delivery, office and other. 

Now we would like to automate this lookup field in this way that when a location has headquarters selected the company will be updated so that the headquarters address lookup field will be filled in automatically. And this is the same for Invoices and delivery.

Is this possible, since there is no option to calculate this field?

Or can I use power automate for this?

Thanks in Advance,

Billy Cottrell

1 ACCEPTED SOLUTION

Accepted Solutions

You can use power automate for this.

 

create a flow that runs on create or update triggered by the drop down. 

 

this is a good use of the swich case action where you can have multiple parallel conditional actions  https://sharepointmaven.com/3-ways-to-build-multiple-conditions-in-microsoft-flow/

View solution in original post

1 REPLY 1

You can use power automate for this.

 

create a flow that runs on create or update triggered by the drop down. 

 

this is a good use of the swich case action where you can have multiple parallel conditional actions  https://sharepointmaven.com/3-ways-to-build-multiple-conditions-in-microsoft-flow/

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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