Unanswered

Multi-Select Person field with null or blank and Single person value

(0) Share

Report

Posted on by Community Power Pla...

I have a multi-select person field with blank as well as single person values in it. I tried passing this logic in

if(equals(triggerBody()?['Location 2']?['Claims'],''), null,split(triggerBody()?['Location 2']?[Claims],';') it is saying 'expression is invalid. Is there a way to load null multi-select person field?

Thank you

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 32,856 Most Valuable Professional on at

Like (1)

Report

Re: Multi-Select Person field with null or blank and Single person value

Hi @Anonymous,

In your expression you are trying to retrieve the multi-person field from the TriggerBody.

Looking at your setup that reference seems to be incorrect, since you are using a Manually trigger a flow action (which does not have a multi-person choice field).

I would suggest to look at the item and empty functions. With these you should be able to refer to a specific field of an item and check if it is blank/empty in an expression. Let me know if you need any additional help with this.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Multi-Select Person field with null or blank and Single person value

Okay I will run it again.

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Multi-Select Person field with null or blank and Single person value

Hi @Anonymous

@Expiscornovus Thanks for providing the detailed steps.

I have noticed the end bracket for the IF() expression is missing, hence getting the invalid expression?

if(equals(triggerBody()?['Location 2']?['Claims'],''), null,split(triggerBody()?['Location 2']?[Claims],';'))

Was this reply helpful? Yes No