cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
afjm
Level: Powered On

Modify "Visible" test of a dropdown option

Is it possible to modify the "visible" test of a form in an edit field? 

My data has a set of usernames which are comprised of first names and last names such as:  "lastname-FirstInitial"

I want the end users to be able to see the first name and last name of an individual that can be grabbed from a lookup as such:

LookUp(CachedContact, Title = DataCardValue8.Selected.Value, firstname & " " & lastname)

For the choices in the drop-down while the actual backend that is being changed is actually the username. Is this possible? 

If this is still confusing I want the end user to see:

"FirstName LastName" that is grabbed from the lookup above as the selectable options in the dropdown, but I want the actual value that's being changed to be the username that corresponds to these individuals. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Modify "Visible" test of a dropdown option

To pull in two fields to a dropdown you will have to use a ListBox (I can't think of any other way to do it), It will let you pull in more than one column at once. 

 

I am not sure if I can explain this good but I am going to try (sorry if I don't). What I do when I want to change one SPList off another that is changed is I make a form for each..one is hidden and one is visible...the hidden is the one that is changed off the selection of the first. Then you have to have a gallery (also hidden) that is tied to the same SPList as the hidden form.

 

The gallery filters for the shared field - example Filter(SPList2,Title=DataCardValue.Text) -- the data card value is the field that ties the two on the visible form). So this is basically going to make the Gallery only show one item from your second SPList, the one that it has in common with the first SPList (that you are editing).

 

Then the hidden form (that is for SPList2) is pulling in whatever item is selected in the gallery. From there you can put in what fields you want carried over and updated on the SPList2 off of the SPList1 selection.

 

I sometimes am not great of explaining stuff on here so if this remotely sounds like it will be helpful to you and you would like me to do a few screen shots to explain better let me know. 

 

Good luck!

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Modify "Visible" test of a dropdown option

What data source are you pulling the LastName-FirstInitial from...is this a SP List or something that you have the names in?

 

Also, when you refer to username...do you mean from 365User Profile or something else or is that another column from the same source as the LastName-FirstInitial?

afjm
Level: Powered On

Re: Modify "Visible" test of a dropdown option

I'm pulling all data from a sharepoint list.

 

The username exists in two separate lists, one holds team information & one holds contact information. The one I am modifying now is from the team list which holds information as:

Team Name (Title Column)

First Contact (Username I was talking about)

Second Contact (Also username)

 

The Information I want to utilize as the display text comes from the contact information list which is laid out as follows:

Username I was discussing (Title Column)

First Name

Last Name 

Email

Etc 

 

So I'm attempting to display "FirstName LastName" as the selectable dropdown options as the visible text, but on the back end be modifying the team list & which username corresponds to which contact. 

Super User
Super User

Re: Modify "Visible" test of a dropdown option

To pull in two fields to a dropdown you will have to use a ListBox (I can't think of any other way to do it), It will let you pull in more than one column at once. 

 

I am not sure if I can explain this good but I am going to try (sorry if I don't). What I do when I want to change one SPList off another that is changed is I make a form for each..one is hidden and one is visible...the hidden is the one that is changed off the selection of the first. Then you have to have a gallery (also hidden) that is tied to the same SPList as the hidden form.

 

The gallery filters for the shared field - example Filter(SPList2,Title=DataCardValue.Text) -- the data card value is the field that ties the two on the visible form). So this is basically going to make the Gallery only show one item from your second SPList, the one that it has in common with the first SPList (that you are editing).

 

Then the hidden form (that is for SPList2) is pulling in whatever item is selected in the gallery. From there you can put in what fields you want carried over and updated on the SPList2 off of the SPList1 selection.

 

I sometimes am not great of explaining stuff on here so if this remotely sounds like it will be helpful to you and you would like me to do a few screen shots to explain better let me know. 

 

Good luck!

View solution in original post

afjm
Level: Powered On

Re: Modify "Visible" test of a dropdown option

That actually makes a good amount of sense to be honest! Thank you! Smiley Happy 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 175 members 4,971 guests
Please welcome our newest community members: