Hi, I am trying to update formula using drop down filter however it's not updating and returned below error. It appears, it;s trying to update the operator (in formula) while selecting the value from drop down. In formula - it;s quite simple and I would like to update the values based on drop down selection. Please suggest where I am doing it wrong.
Error
Solved! Go to Solution.
Hey @tandon, in your action tool, have you reduced what you are replacing to just include the 001A part of the formula?
Will need to tick 'Replace a specific string' and reduce it down to just that, like so:
I can;t upload the files as it;s blocked however I can share settings. please refer below
Filter settings -
Drop down setting
Hey @tandon,
Think you are doing this, your updating the operator not the value:
What you need to do is update what is being filtered on by highlighting here:
Thanks @IraWatt , I applied above setting however received below now. I tried to open debug but I can still see old values which means values not updated via dropdown.
Hey @tandon,
Add two brows tools like and add them as outputs in the interface designer to see what your filter is doing.
I've attached an example workflow:
Also make sure to run the workflow if you change any of the data before running the app in debug.
Thanks @IraWatt . I added output and can see values appeared however operand variable didn;t updated with selected value
No worries @tandon :) looking at my example I have set a value in the filter as a default which I think overwrite, strangely you don't seem to have a value there.
Try setting your filter to custom
Then replacing the specific section of it like this
Yes. agreed with you as I expect value here but anyway it;s working as I can see output. thanks for your help.