Skip to main content

Notifications

Announcements

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : HsAWl4Hnm/72V5WYp/sb37
Power Platform Community / Forums / Power Automate - Building Flows / Update File Properties...
Power Automate - Building Flows
Answered

Update File Properties - Lookup Column

Like (0) ShareShare
ReportReport
Posted on 1 Jul 2022 19:48:07 by JamesMac 77
I have a Power Automate Flow that creates a file in a document library, which works as expected. However, when I add an action to update the file properties, document library lookup columns do not show up as a property that can be updated in the Flow. Does anyone have any suggestions on how to update a document library lookup column?
 
JamesMac_0-1656704816828.png

 

  • LiveLife Profile Picture
    LiveLife 8 on 15 Nov 2022 at 21:15:17
    Re: Update File Properties - Lookup Column

    Sorry if this is off topic but I do have a similar problem. I need to update the "Author" file property for existing documents. I am a newbie and would appreciate the steps to do so.

  • Verified answer
    JamesMac Profile Picture
    JamesMac 77 on 11 Jul 2022 at 16:06:35
    Re: Update File Properties - Lookup Column

    I just figured it out.  The lookup column cannot be associated to the (linked to item) value.

     

    I changed the lookup column to associate with ID and it worked.

    JamesMac_0-1657555573019.png

     

    I changed the lookup column to associate with the Title (User Email Address in my case) column, but not the one associated with (linked to item) and it worked.

    JamesMac_1-1657555580999.png

     

  • JamesMac Profile Picture
    JamesMac 77 on 11 Jul 2022 at 15:58:25
    Re: Update File Properties - Lookup Column
    I deleted the Update File Properties action, saved the flow, added the Update File Properties action and still do not see the lookup column.  If I use the Update Properties action for a list that has a lookup column, the lookup column shows up as a property that can be updated.  The issue is only occurring for libraries.
  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft on 06 Jul 2022 at 06:38:09
    Re: Update File Properties - Lookup Column

    Hi @JamesMac ,

     

    Please try to delete this action and add it again. I can find this lookup parameter in 'update file properties' action.

    vxiaochenmsft_0-1657089463871.png

    vxiaochenmsft_1-1657089477173.png

     

    Best Regards,

    Wearsky

  • JamesMac Profile Picture
    JamesMac 77 on 02 Jul 2022 at 19:16:40
    Re: Update File Properties - Lookup Column

    I had added the Get Item (properties), but the lookup column was not in the output. I'll run it again later and grab a screenshot of the output. 

  • JonDoesFlow Profile Picture
    JonDoesFlow 1,304 on 02 Jul 2022 at 13:06:36
    Re: Update File Properties - Lookup Column

    I think you would need to use a Get Item (properties) only step after the item has been created and then use the ID from that to update it’s properties. 

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

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,636 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans