How to get Multiple column values in workflow

Question

Hi, Here I'm looking for a solution to my problem that is related to SharePoint designer workflow. I want to highlight my problem here- I have 2 SharePoint lists on my SharePoint Server. 1.LocationRoom   2.MeetingRoomBooking and on behalf of Id we are collecting information into MeetingRoomBooking list in a column(Room2ID) as well     Now I want that I loop through every value of Room2ID in MeetingRoomBooking list and get the details from LocationRoom list on behalf of these id's separated by a comma. and want to store those details in a variable and then want to send these details in an email. like if ID is 1,4,7 etc than the related columns values will be stored in a variable through the workflow.
Please feel free to ask me if you don't understand my scenario. Help me out in this scenario. Thanks!

Manpreet Singh · Answer

So in the variable, you are getting the id of that value, right?   Cheers !
Manpreet

Vipin Tyagi · Answer

No, I'm not using lookup column

Manpreet Singh · Answer

Hi Viipiin,   Are you using look up columns?   Cheers, Manpreet