Aug 25 2021 10:03 AM
Hello everybody,
I'am currently importing some objets from an external MS application to make a PowerApp to sustitute it.
This objets have properties with the id relation between the objects.
I have researched and the unique way I found to create 'lookUp' columns is by creating a new one because the ones existing are not able to be updated.
For so, It looks like Is needed to:
Is this right? In this case, anyone could share an example?
Thanks in advance,
Aug 26 2021 01:59 AM - edited Aug 26 2021 02:01 AM
@AlexBlanes you won't be able to do it with a flow in Power Automate, but there is a fairly simple solution depending on the number of items you have in the list. Create the new lookup column. Make sure the text column has only valid values that the lookup column can find (otherwise you'll get an error in the next step). Then go to Edit in grid view and select your text items in batches of no more than 100 and do a copy (ctrl+c). Then go to the first row in the lookup column and paste (ctrl+v).
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Aug 26 2021 02:49 AM
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?
Aug 26 2021 03:29 AM
@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
Feb 27 2023 01:11 AM
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 field@RobElliott