How to add list collector of location in the approver table for if approver is the Contact

[Samiksha2]

Hi All,

I have a catalog item in which a variable is a list collector (cmn_location). 
In the location table I have added the contact for each location.
The flow is approver will go based on selected location's contact. (This is working).
The requirement is in the approver table that location should be populate for which contact is approving.

For example,
In the location table
Location 1 has User 1 contact

Location 2 has User 2 contact

Location 3 has User 1 contact

Location 4 has User 1 contact

And in the catalog item end user has selected Location 2, Location 3,Location4

In the Approver table, in the string value for User 1 Location 3 and Location 4 should populate and for User 2 Location 2 should populate.

The reason behind doing this is they want a report where stakeholder can see who approves which location.
I have created a database view for requested item and approver table.
But I am unbale to get the list collector values separately. 

If any other way to to do this, please let me know.

Thanks,
Sam
 

[Samiksha2]

Hi @Ankur Bawiskar ,
I have already tried, but all locations lists are showing in the list not those two. All location whose contacts is Biprajit and Daniel.
Thanks,
Sam

[Ankur Bawiskar]

@Samiksha2 

share the final database view configuration when you included the 3rd table

[Samiksha2]

I have selected these two locations

But in the database views all locations are showing in which approver is the contact.

Thanks,
Sam

[Ankur Bawiskar]

@Samiksha2 

Biprajit and Daniel are contacts for other locations, so it's bringing those as well

you will have to include these 2 tables as well which holds the list collector variable value after RITM is submitted

sc_item_option and sc_item_option_mtom 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Samiksha2]

But i have one doubt @Ankur Bawiskar ,
List collector field has two values. will it separate based on location?

Thanks,
Sam