I tried to understand your problem as much as I could. In your case, have you checked if the ‘GetList’ microflow is being triggered every time the item in the drop down is selected?
Also, there is no need to store your listview in the footer of the Dataview. If you can, you should put it in the body right underneath your drop down.
You might have a refresh issue here along with a few issues anyway.
Firstly, You are creating an object type of DropDownContext as a datasource microflow on your page. This microflow only has a create action so if the context object was to be refresh, it will create a new object each time which means you may lose your selection.
Secondly, Many other issues
If I was you, this is how I will structure my entity
Your dataview page context, should be the dropdown wrapper which will store many dropdownContext objects (In the dropdown)
Each DropdownContext should have a list of their own (I am assuming that this is what you are doing)
In your page, you can retrieve the list via association with the DropdownContext.
In your case, you might not need to do this as you want a new list on every selection so just make sure your logic is triggering each time you select a value in the dropdown, this will mean the context is not refreshing
I think i found my problem.
My dropdown has an event. After every change, start the microflow.
It looks like, my SQL Statement isn’t working.
This is my microflow:
For test purpopse, I added some info messages.
Everytime i change my drop down, i get this info:
You can see, i get the correct value from the dropdown.
BUT, my query does not give me a value back.
This was my first try:
I get no error and no value back:
But when i change my SQL to this:
I get a list back.
Because it is always the same sql statement, the value isn’t changing.
How can i run the SQL statement with the parameter?
I already created a variable but this is also not working:
Also when i write the complete string into my variable and just call it, its not working.
How can i get access here to my value from the variable?
Probably best to set up a call so that I can help you through debugging your microflow.
Send me an email and let me see how I can help.