Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Sharepoint Lookup Column no retrieves in flow

(0) ShareShare
ReportReport
Posted on by 145

Good day Everyone,

 

I'm trying to automate the update of my inventory based on the status of another list in sharepoint. The inventory has a lookup column that indicates the user that has the device assigned. When that the user item get modified in the other list i want the flow to filter the devices in my inventory that the user has based on the lookup column. However, when i tried to catch the name in the compose it just show Name#Id not its field Name.

 

Can somebody give me a hand?

  • Davidx23 Profile Picture
    Davidx23 145 on at
    Re: Sharepoint Lookup Column no retrieves in flow

    Hi Scott,

     

    I'm clear on that but what i can't identify is the name of the lookup column cause it seems that is not the one showed in tha Dynamic content. I'll attached screens for your reference.

     

    Please help!

    Pa1.PNGPa2.PNG

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Sharepoint Lookup Column no retrieves in flow

    @Davidx23 

    In your Compose action, select the Column name followed by value.  So if the column name is My Data, select My Data Value from Dynamic properties.  This will also be true when you use a choice column.

    image.png

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard