cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALBordelon
Advocate II
Advocate II

SharePoint List Customization- Lookup Field- Additional Fields Only Updating after Saved

I am using SharePoint List Customization for a Travel Form.  The Travel Form List has a Lookup field to a Countries List that contains the Risk Level for each Country.

 

The goal is to display the Risk Level when a user selects a Country in the Travel Form.   The Lookup field successfully displays the Countries in the Countries List, but the Risk Level only completes after the Form is Saved.  

 

How do I get the Risk Level to display when the user selects a Country?

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@ALBordelon 

A question - Are you only displaying the Risk level, or are you also trying to save this in the current list?

If so, then you can set the Text property of a Label to something similar to this:

   Lookup(countryDataSource, country=yourDropDown.Selected.Value).RiskLevel

Of course, replace the references above with your valid references.  And, depending on your dropdown items property, the .Value may or may not be valid.

 

I hope that is what you need and it is helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

1 REPLY 1
RandyHayes
Super User
Super User

@ALBordelon 

A question - Are you only displaying the Risk level, or are you also trying to save this in the current list?

If so, then you can set the Text property of a Label to something similar to this:

   Lookup(countryDataSource, country=yourDropDown.Selected.Value).RiskLevel

Of course, replace the references above with your valid references.  And, depending on your dropdown items property, the .Value may or may not be valid.

 

I hope that is what you need and it is helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

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,886)