88Hello,
Please help, I am trying to achieve vlookup from one list to another but that functionality for sharepoint list is only for lookup. Can JSON formula be used to do a vlookup functions in list? Or is it powerautomate the best option?
I tried what I have see online but it didnt work.
https://stackoverflow.com/questions/69020473/automate-vlookup-using-sharepoint-lists-and-flow and https://sharepoint.stackexchange.com/questions/302829/replicating-a-vlookup-in-microsoft-lists
Please see attached screen capture.
Looking forward to hearing from those who are willing to help.
Thank you so much!
