topic Please help to correct Lookup & If-condition in Pipeline in Pipelines

Please help to correct Lookup & If-condition in Pipeline

HelloTheSun — Fri, 05 Jul 2024 14:09:14 GMT

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

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

Thank you

Anonymous — Mon, 08 Jul 2024 08:40:52 GMT

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.