Answered

Update File Properties - Lookup Column

(0) Share

Report

Posted on by JamesMac

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?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

JonDoesFlow 1,304 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
JamesMac 77 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @JamesMac ,

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
JamesMac 77 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

JamesMac 77 on at

Like (0)

Report
Copy link

Link copied!

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.

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.

Was this reply helpful? Yes No
LiveLife 8 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No