web
Youโ€™re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 2v0mV+vqYsnXYORn6GlBdY
Power Automate - Using Connectors
Answered

SharePoint Lookup, how to reference value from dropdown

Like (0) ShareShare
ReportReport
Posted on 12 Dec 2019 10:20:59 by

Hi

 

Custom SharePoint list with a form in Powerapps, one column is a lookup to a custom list with 2 columns, title and driver-domain

My goal is to set a different field to the value of driver-domain (for the moment I'm trying to set a variable)

If I add a standalone dropdown it works, but not on the sharepoint integration form

 

Works:

UpdateContext({varDriver: LookUp(Drivers, Title = Dropdown1.Selected.Title, 'Driver-Domain')})

 

Doesn't work:

UpdateContext({varDriver: LookUp(Drivers, Title = ThisItem.ToDriver.Value, 'Driver-Domain')})

 

 

drivers.jpg

 

Form.jpg

 

  • v-litu-msft Profile Picture
    on 13 Dec 2019 at 01:20:14
    Re: SharePoint Lookup, how to reference value from dropdown

    Hi @Anonymous,

     

    I am glad you find a way to solve your problem.
    If your problem has been solved, You could go ahead and mark the post as solved by clicking โ€œAccept as Solutionโ€ so that this thread will be marked for other users to easily identify!

    Best Regards,
    Community Support Team _ Lin Tu

  • Verified answer
    Community Power Platform Member Profile Picture
    on 12 Dec 2019 at 13:43:10
    Re: SharePoint Lookup, how to reference value from dropdown

    found it ๐Ÿ™‚ DataCardValue31.Selected.Value

     

    UpdateContext({varDriver: LookUp(Drivers, Title = DataCardValue31.Selected.Value, 'Driver-Domain')})

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

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 Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Loading complete