This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 70%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
1.Condition statement for String is not working as expected.
it had to fail when the string in contains but it's passing.
I am trying to filter for No Rows according to the schema generated.
@ChaitanyaNaykodi-MSFT still not able to get the If statement.
I want to achieve
If row label is Y then I want to output as No, in that Row
I wrote: @if(equals(item()['dataCells'][2]?['label'], Y), 'no', 'yes')"
I think instead of equal I need to use string compare not sure can u guide
I fixed this with a condition.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 59%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Hello @Lubdha Dolas , Glad to hear that you were able to fix the issue. Can you please post your solution here? so that any community member facing similar issue can refer it. Thank you!
@ChaitanyaNaykodi-MSFT So for the condition to check the rows was simple.
I am already using the expression item.
I have used the Control for condition
I have used the items function so, to check the empty file. checked the out of the table. and filter it accordingly. as :
"expression": {
"and": [
{
"contains": [
"@{body('HTTP')['factMap']['T!T']['rows']}",
"[]"
]
}
]
},
may be if
(equals(item()['dataCells'][2]?['label'], 'Y'), 'no', 'yes')"
this will work
Hello @Lubdha Dolas , apologies for the delay. You can use the the string function in the following manner if(equals(string(item()['dataCells'][2]?['label']), string(Y)), 'no', 'yes')". Please let me know if this does not help resolve the issue, I will be glad to continue with our discussion.
Hey @ChaitanyaNaykodi-MSFT thanks for your revert. I just used
if(equals(item()['dataCells'][2]?['label'], 'Y'), 'No', 'YES')
with out string and it had worked