Sharepoint List - VLOOKUP function issue

Question

Hi,

I've created a microsoft list which will be "list 1", this list feeds from 2 power apps and another list called "list 2". The first PA creates a new item in list 1 which has its own columns and some VLOOKUP colums which bring info from list 2.

My issue is, when a value from list 2 is updated, it modifies previous entries in list 1's values which I would like them to stay the same so I keep a record.

Is this possible?

Tyvm for the help =D

Answer 1

Dear Gutierrez Alfonzo,

Thank you for posting in Microsoft Community.

Based on the description, you want to stay the list 1 values lookup from list 2. Unfortunately this is expected behavior that once the list 2 value has been updated, the list 1 using lookup column will be updated too. I would suggest you to submit a Feedback for this feature to retain original value of lookup column.

You can check the previous value of the item from lookup column by checking the version history. Click on the vertical ellipses button beside the item > click on version history > click the drop down arrow then click view.

We look forward to your response. Thanks for your kind understanding. Stay safe and healthy always.

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

Sincerely,

Zee | Microsoft Community Moderator