Newbie question: IF and empty expression

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Newbie user, need help with this expression:

if(empty(item()?['InvoiceRecipient.DisplayName'],' ',item()?['InvoiceRecipient.DisplayName']))

Have a SharePoint list with a column InvoiceRecipient.DisplayName

Need an expression to display a blank if that row in that column is empty and return the value if not empty. But it's either giving me an error or showing a blank even when there is a value. Anything wrong with expression?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @Anonymous ,

you've got the closing ) for the empty expression at the end instead of after the value to check. And I think that to update an empty value to a people picker field you must use 'null' as the value:

if(empty(item()?['InvoiceRecipient.DisplayName']),null,item()?['InvoiceRecipient.DisplayName'])

Was this reply helpful? Yes No
Bokaboi 47 on at

Like (0)

Report
Copy link

Link copied!
Hey,
I'm also a bit of a newbie and though I'd jump on this tread as I'm having a similar issue.
I have a Create HTML Table action in which I'm wanting to pull through a date of issue, and an expiry date. If the field is empty, I want to return "Missing".

Raw outs from filter array

This is the code I'm trying which gets a red error message.
if(empty(item()?['Field_3'])),'MISSING',item()?['Field_3'])

Was this reply helpful? Yes No
mmicsa 40 on at

Like (0)

Report
Copy link

Link copied!

Just in case someone stumbles across this like I did, here's how I resolved it in the end:

if(contains(item(),'the item'), item()['the item'], '')

Hope it helps someone.

Was this reply helpful? Yes No