Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Okay I will run it again.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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],';'))