Passing data from csv to bookmark in automation

[Defo]

Hi everybody! I am new to QAA and I am working on a way to let the users filter data using an external file (not suitable to use the data editor, each user has a different list to filter).

I have already a solution in the UI to let them upload a list using a variable, but the performance are poor. The lists that are uploaded count 50k or more distinct rows.

I am trying to create a work around with QAA. Now, I am reading the file with the Onedrive connector and using Select Field Value + Create Bookmark blocks in order to add a bookmark to the user UI to let him filter the app.

I have two main issue in this POC:

1. the bookmark is added to the app after a lot of time the end of the automation -> need to reduce this time
2. I am struggling to pass the value from OneDrive to the Select Field Value block -> need to find a way to make this step work. I get no error but the selection is not performed.

Any suggetion would be great!
Davide

[Defo]

Hi @AfeefaTk ,

Tried making a new one from scratch but it doesn't work. Tried using a value from the lookup but nothing.
There is a work-around to this, maybe using the "Select Field Values by query" block (that works but only with one value)?

Thanks a lot for your time