Please help to correct Lookup & If-condition in Pipeline

[HelloTheSun]

Please help me to correct Pipeline in Lookup and If-condition

1. I have data in a Warehouse which collect data [col : 1]
2. Build pipeline for lookup data in warehouse [col : 1]
3. And create If-condition and define the condition : @equals(xml(activity('Lookup1').output.firstRow),'1') 
4. If is True sent message value 1 and 0 when False in MS Team
5. Correct is sent message 1 but now show message 0 ???

Thank you

[Anonymous · Accepted solution]

Hi @HelloTheSun ,

Try to modify your formula:

Assuming the column name in the data warehouse is [col: 1], the correct expression would be:

@equals(activity('Lookup1').output.firstRow['col'], '1')

 Or if the column name is indeed 1:

@equals(activity('Lookup1').output.firstRow['1'], '1')

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.