Forum Discussion
Convert table to list and use that in function
Hi rbabu ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Hello,
Thanks for following up. Am not very sure what to do from here, let me explain how my 2 table looks now.
So LOV has the values in a columns which could be countries for now. Assume they are A&B.
and Sheet1 has the column 'Customer Country' which I need to validate. I am unable to use Text.Split in sheet1 to make LOV(Value1) a list as it doesnt show up in the drop down for me to select 'Value1'
I want to do the below (I assume this is what you asked me to try, convert the LOV to a list first), but the highlighted values are not showing as a drop down when I type them.
Do correct me if my understading is right what you guided me to.
Thanks.
Hi rbabu ,
Thank you for the detailed explanation and screenshots. You're on the right track. Just convert the LOV column into a proper list using Drill Down in Power Query. Then, add a Custom Column with this formula.
This will return TRUE if the value exists in the list, and FALSE if it doesn’t. No need for Text.Split() since you're working with a list, Power Query handles it automatically.
FYI:
I hope this helps..