Modify "Visible" test of a dropdown option

(0) Share

Report

Posted on by afjm

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
afjm 13 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

rebeccas 2,591 on at

Like
a
(1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
afjm 13 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No