Forum Discussion

rbabu's avatar
rbabu
Frequent Visitor
1 year ago
Solved

Convert table to list and use that in function

Hello friends,   I have managed to convert my table to a list which now looks like this for e.g "Afghanistan","Albania","Algeria","Andorra","Angola" Name of the list - CountryLOV Now I need to us...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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.

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

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.

 

rbabu's avatar
rbabu
Frequent Visitor
1 year ago

Hello, sorry for the delay. I have trying to do what you suggested without luck. 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 am not able to attach my pbix to this reply. If you dont mind, could you try on your side pls. two tables. 1 table has the country column and other table has LOV (in the form of tables)

 

Thanks very much!