ADF Expression @lessorequals question?

Mike Kiser 1,536

Hi @Nasreen Akter

I have the expression in my If Condition:

@lessorequals(int(item().virtualWorkPercentage), 0)

Without notice, I found out that the 0 can also be a NULL; how can I handle both?

Thanks!
Mike Kiser

KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2021-05-26T06:21:23.14+00:00

Hi @Mike Kiser ,

We still have not heard back from you. Just wanted to check if the below suggestion from Nandan was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.

1 answer

Nandan Hegde 32,026 Reputation points MVP

2021-05-21T15:54:05.687+00:00

Hey,
You can use the below expression
equals(coalesce(item(). Virtualworkpercantage, ' '), ' ') to check whether the value is null and based on your requirement do the needful in your if condition. Is your ask to make null values as zero?

Solution:

@lessorequals(int(coalesce(item().virtualWorkPercentage,0)), 0)
Please sign in to rate this answer.
Mike Kiser 1,536 Reputation points

2021-05-21T16:35:15.547+00:00

Hey @Nandan Hegde

Thanks so much; I wasn't clear.

I need to be able to accept either NULL or 0 (zero); the data from the source comes in a either one.

I appreciate your help!

Thanks!
Mike

Gajanan Hegde, Nandan 6 Reputation points

2021-05-21T16:43:36.167+00:00

So just to clarify, your ask is the column may contain zero or null value?
And in case if the column contains null, we treat it as zero.
Is my understanding correct?

Nandan Hegde 32,026 Reputation points MVP

2021-05-21T16:58:42.487+00:00

@lessorequals(int(coalesce(item().virtualWorkPercentage,0)), 0)

Mike Kiser 1,536 Reputation points

2021-05-21T18:23:30.88+00:00

Yes, exactly! Thanks!! @Gajanan Hegde, Nandan

Nandan Hegde 32,026 Reputation points MVP

2021-05-24T14:10:58.623+00:00

Hey ,
Can you please accept it as answer in case if it was helpful.
I have updated my initial answer to have the solution.

Nandan Hegde 32,026 Reputation points MVP

2021-06-16T11:47:22.67+00:00

Hey @Mike Kiser ,
an you please mark it as answer and upvote in case if the answer was beneficial as it may help other community members as well
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ADF Expression @lessorequals question?

1 answer

Your answer