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

one canvas, two data list connections, filed 2 from list B to show data based on data from Field 1 from list A

Hello,

 

i have a canvas app and i have two data SharePoint list connections:

  • List A
  • List B

 

at my canvas i have the below fields:

  • Field 1 which is the Name of a user from List A
  • Field 2 which is the Hostname of the same user but from List B

 

how can i show the hostname value from field 2 based on the name of the user?

 

thank you in advance.

2 REPLIES 2
zmansuri
Super User
Super User

UserName
A
B
C

 

 

 

HostNameUserName
Test1A
Test2B
Test3C

 

You will need schema like this to get 1 field based on another field.

Dropdown1 will contain usernames.

For the field You can just write 

LookUp(List2,UserName=DropDown1.Selected.Value).HostName

 

This will go to list to and compare selected user name against list 2 and give relevant hostname

Thank you @zmansuri  where do i put the formula?

 

on the Datacard or at the Datacardvalue and where exactly?

 

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,280)