Create a text version/copy of a lookup column in a Sharepoint List

Question

Hello,

I have a long SharePoint List which contains some lookup columns. I need to do the following:

1. Duplicate an entire lookup column.
2. Have the duplicate column display the lookup values as text.

I have been trying to figure out how to do the above all at once using Power Automate, but I am very new to designing flows, so have not been successful. Specific details are below:

In the below LB_List table, I am trying to copy and make a text version of the Custodial_Group column. This column is a lookup column, which is pulled from the below Faculty_Units table.

If this can be done (in PowerAutomate or through any other means), I would be grateful for instructions that a novice can follow. 

Thank you :)

Answer 1

Dear Nic,

Thanks for your updates.

I noticed that the the CustodialGroup column seems to be linked with the Title column. So the Uri needs to be _api/web/lists/GetByTitle('Test20210225....List')/items(@{items('Apply_to_each')?['ID']})?$select=CustodialGroup/Title&$expand=CustodialGroup/Title.

I suggest you re-add the connector and then run it to see the result.

Thanks for your effort and time.

Cliff

Answer 2

Hi Cliff,

Thank you so much for the additional advice and my apologies for the lack of reply during the holidays.

As per your last message, I removed and re-added the connectors and changed all references throughout the flow from 'Column 1' to 'Title'. Unfortunately, the exact same error appeared.

There must be something specific about my data that is preventing this method (and the previous methods that you have suggested) from working. I am hoping that someone from within my organisation might be able to find a method that works on my data. If so, I will be sure to post it here!

Thank you so much for your ongoing advice and troubleshooting Cliff, I am very grateful for all of the effort you have put into this.

I will mark this thread as solved, as the first method that you proposed on 22 March did work (just not on the List that I need it to!).

Kind regards,

Nic

Answer 3

Dear Nic,

Thanks for your updates and kindness.

Welcome to post a new thread on our forum at your convenience if you encounter any issues in your environment.

Have a nice day!

Cliff