web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : n75lriD7j3NoXiWPV+OBx2
Power Platform Community / Forums / Power Apps - Building Power Apps / one canvas, two data l...
Power Apps - Building Power Apps
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 21 Sep 2021 16:04:12 by kouliscon 247

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.

Categories:
Connectors
Connecting to Data
General Questions
  • kouliscon Profile Picture
    kouliscon 247 on 21 Sep 2021 at 16:45:02
    Re: one canvas, two data list connections, filed 2 from list B to show data based on data from Field 1 from list A

    Thank you @zmansuri  where do i put the formula?

     

    on the Datacard or at the Datacardvalue and where exactly?

     

  • zmansuri Profile Picture
    zmansuri 6,048 Super User 2024 Season 1 on 21 Sep 2021 at 16:23:51
    Re: one canvas, two data list connections, filed 2 from list B to show data based on data from Field 1 from list A
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans