Hi All,
I've been stuck on this for a long time please advise how to achieve this.
Here's what I am trying to do, I have a login page after the user enters their credential and logs in(backend is supabase). I am trying to retrieve a value from a column from Supabase table. Now the value which I am trying to retrieve is list of strings from a column.
Here's a backend query which returns a single row because its filtered based on the ID(logged in user id) field
I am trying to use the action output variable output and take a single column values from that row and assign to a app state variable which has list of strings as datatype.
The issue I am facing is I am not able to Update a value(list of strings) to an app state variable from the action workflow. When I select "Update app state variable" in action workflow I get the below option
Options under "Select Update type"
Now no matter what option I select from the below to set value I am not able to achieve the desired results.
from the above option i selected Add to list and Filter Few items and selected as below. But this only assigns one value as expected. But how do I assign all values to the app state variable?
If I select "Set Value" I get the below option and No matter which ever I select the Available output keeps going and never stops. I dont understand what mistake am I doing please advise.
Should I use any other "Update types"? If so how do I get it to save the whole list value??