Forum Discussion
How can I change SP list text column type to lookup?
Wow thanks. In my case I have to be in the grid view to be able to copy just the column I need.
Anyways this will take me a hole time. Now I've to copy two thousands but I have another object with eleven thousand elements with three relations... Are you sure is not possible to update with Power Automate?
AlexBlanes yes I am because when you add the update item action, for the lookup column Power Automate it describes it as, for example, AircraftTypeLU Id. If you just select the text column as a custom value for the lookup column it won't put anything at all into the column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
You can find many example on how to make it with powerautomate but you need to use a sharepoint get items to populate the lookup fieldRobElliott
