Power Platform Community Forum Thread Details

I have a filter query when inputted directly into the 'sharepoint get items' step, just works.. but when I put this into a conditional and put it into the get items step it fails.

I then took the if condition out of the odata filter and put into a compose step and then the compose was my odata field.. this failed too..

but when I took the output of the compose, copied it and pasted it into the odata filter, everything works.. So needless to day I'm lost in what is going on..

here is my conditional.. I had to double quote the single quotes to escape them but other than that this is what works fine in the compose field

If(equals(triggerBody()['text'],'Alpha'),'(substringof(''@{triggerBody()[''text_3'']}'',AVehicles/Title) or substringof(''@{triggerBody()[''text_3'']}'',TADeploym/Title))',If(equals(triggerBody()['text'],'Beta'),'(substringof(''@{triggerBody()[''text_3'']}'',BVehicles/Title) or substringof(''@{triggerBody()[''text_3'']}'',TBDeployme/Title))',If(equals(triggerBody()['text'],'Gamma'),'(substringof(''@{triggerBody()[''text_3'']}'',GVehicle/Title) or substringof(''@{triggerBody()[''text_3'']}'',TBDeploym/Title))',If(equals(triggerBody()['text'],''),'(substringof(''@{triggerBody()[''text_3'']}'',AVehicles/Title) or substringof(''@{triggerBody()[''text_3'']}'',BVehicles/Title) or substringof(''@{triggerBody()[''text_3'']}'',GVehicle/Title) or substringof(''@{triggerBody()[''text_3'']}'',TADeploym/Title) or substringof(''@{triggerBody()[''text_3'']}'',TBDeployme/Title) or substringof(''@{triggerBody()[''text_3'']}'',TBDeploym/Title))','nothing'))))

Please advise.

Thanks in advance

Categories:

Building flows