Gallery chaining dynamic drop down

[Jaimon_office]

Hi Team,

I have a chained app which needs selection prompt from user for a filter. For this I used the list box option from the interface section.

To avoid the multiple users updating same temp files conundrum, I am creating dynamic folders(see examples id1 and id2 folders in the folder attached) based on GUID from the gallery. This works fixes issues with my other concerns but brings the confusion for this app on the source of list box data as source we add in the list box is a static path.

I tried applying cross tab on the 'Main.yxdb' on the app before this and wrote an additional file called 'GL in COls.yxdb'. The tried the approach in the file(2.yxwz). But while testing as chained app, the list box is only giving me data based on last metadata which it ran as a workflow.

Could someone help me to solve the problem? In essence, the workflow need to dynamically update the list box by identifying right folder.

[Jaimon_office]

To add on the above, after checking few posts(Solved: Chained Gallery app Concurrent Users Conundrum - Alteryx Community) I tried 2 ways(writing in relative paths and updating second app xml from the first app) but both required write access on the staging folder which unfortunately as user I don't have