Invalid expression issue while using empty statement

(0) Share

Report

Posted on by OOlashyn

3,496 Most Valuable Professional

Hi All,

I am building a flow that gets info from external source and then passes it as parameters in child flow. I wanted to have a validation on one of the parameter directly in the input box but got an error: "The expression is invalid". Here is my expression:

if(empty(body('Parse_Company_Information')?['address']?['state']),"NOT_FOUND",body('Parse_Company_Information')?['address']?['state'])

Invalid PA expres...

I have the same question (0)

All responses (6)

Answers (2)

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Invalid expression issue while using empty statement

I think you want IsBlank() not Empty(). There is no Empty() function. IsEmpty is used to see if a table is Empty and IsBlank is used to see if a string is Blank. So if you are checking to make sure the State value has something in it you use IsBlank().

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Re: Invalid expression issue while using empty statement

Hi @Pstork1 ,

I am talking about Power Automate Flow and there is an empty function (as per docs). The functions you are referring are from Power Apps and as far as I know are not applicable to Power Automate.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,271 Most Valuable Professional on at

Like (1)

Report
Re: Invalid expression issue while using empty statement

Sorry, I've been jumping back and forth between Power apps and Power Automate. But the problem you are having is related to my comment. Empty() is used with tables/records, not values/strings. What you want is the following.

if(equals(body('Parse_Company_Information')?['address']?['state'],''),"NOT_FOUND",body('Parse_Company_Information')?['address']?['state'])

which will test against an empty string.

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Re: Invalid expression issue while using empty statement

Hi @Pstork1 ,

No worries, happens. Unfortunately your suggestion didn't help - I still got the same error. In the end I decided to just have additional condition step and use empty to validate if it is actually null. That worked.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,266 Moderator on at

Like (0)

Report
Re: Invalid expression issue while using empty statement

@OOlashyn ,

There is a small misspeling in @Pstork1 's formula:

if(equals(body('Parse_Company_Information')?['address']?['state'],''),'NOT_FOUND',body('Parse_Company_Information')?['address']?['state'])

NOT FOUND should be surrounded by qoutes (because it is a string), not double-qoutes. In rest the formula is great !

Hope it helps !

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Re: Invalid expression issue while using empty statement

Hi @gabibalaban ,

Yes, you were right - the changing from double-quotes to single quotes helped. Thanks!

Was this reply helpful? Yes No