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
 

[Shivalika]

Hello @Samiksha2 

In the database view you need to add condition in the WHERE Clause. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Samiksha2]

Hi @Shivalika ,
I tried but how should I fetch the variable value of list collector?

[terrillc]

were you able to find the solution?

[Samiksha2]

Hi @terrillc ,
No.

Thanks,
Sam