Hi
I need to filter the query in get items of sharepoint on following conditions
Could anyone please check and confirm whether is there any error in the formula
Condition I required if the Select Type Value is "Request for self" I need to filter Title column with Vertical , if not Title Column with Company Code
Spoiler (Highlight to read)
And>
<Eq>
<FieldRef Name="@{outputs('Get_item_-_User_Info')?['body/SelectType/Value']}" />
<Value Type="Text">Request for self</Value>
</Eq>
<Eq>
<FieldRef Name="Title" />
<Value Type="Text">@{outputs('Get_item_-_User_Info')?['body/Vertical']}</Value>
</Eq>
</And>
<Or>
<Not>
<Eq>
<FieldRef Name="@{outputs('Get_item_-_User_Info')?['body/SelectType/Value']}" />
<Value Type="Text">Request for self</Value>
</Eq>
</Not>
<Eq>
<FieldRef Name="Title" />
<Value Type="Text">@{outputs('Get_item_-_User_Info')?['body/CompanyCode']}</Value>
</Eq>
</Or>
And><Eq><FieldRef Name="@{outputs('Get_item_-_User_Info')?['body/SelectType/Value']}" /><Value Type="Text">Request for self</Value></Eq><Eq><FieldRef Name="Title" /><Value Type="Text">@{outputs('Get_item_-_User_Info')?['body/Vertical']}</Value></Eq></And><Or><Not><Eq><FieldRef Name="@{outputs('Get_item_-_User_Info')?['body/SelectType/Value']}" /><Value Type="Text">Request for self</Value></Eq></Not><Eq><FieldRef Name="Title" /><Value Type="Text">@{outputs('Get_item_-_User_Info')?['body/CompanyCode']}</Value></Eq></Or>
Could anyone please help me to fix this
