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

[jrlindem]

I'm not completely sure I'm following you but in a similar vein...  I have solved for "session" differences by leveraging GUID before.  I've also just put a datetime stamp that includes microseconds as the likelihood of that overlapping is quite low.

As for the gallery directories, you can use [Engine.TempFilePath] or [Engine.WorkflowDirectory] as dynamic, system constants to call for the file(s) exactly where Gallery typically puts them when using \%temp%\.  I've leveraged this so that I don't have to explicitly call out the directory path that Alteryx is ultimately self-generating but is retained for that sessions temp data.

If this sounds relevant, give it a shot.  If I'm way off base... sorry!  -Jay

[Jaimon_office]

Hi @jrlindem : I tried the above and that's when I came to an understanding that whenever we run workflow they get copied to a dynamically created unique subfolder for each process to run independently. from the database As I didn't had the write access on the staging, I moved to UNC path including creating unique directories via workflow. But the data for the tools like drop down/ list box are expected to be coming from previous from any unknown dynamic folder which I am unable to reach as the respective folder name is unknown before. It would have been better if the interface tool configuration(Ex: list box external values) path could be set dynamic similar to the normal output tool.

My concern is on accessing the temp file created with GUID(I make GUID as the folder and temp files inside that) on the interface tool like list box. Have you had any luck on this?

[jrlindem]

I think more what i'm recommending is you don't worry about the folders, but focus more on making the temporary excel or YXDB file unique to the session by using the GUID or timestamp.  The workflow should recognize that unique file as the one associated with the run at that point.  No need to sub-organize in different folders if you're handling it this way.

-Jay

[Jaimon_office]

Yes, that's correct. I made it that way while exploring things. 😅

We could make the files unique by prefixing with timestamp and GUID. While chaining the flows I could do this app on the previous run and then write to a safe location on network drive. The problem for me is then how would I access this temp path dynamically on the list box(as an example) on the current app. As in the above screenshot, GUID in the interface tool cannot be updated right? or is it possible somehow?