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
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 (1,231)