Unanswered

Trying to compare an object property using Switch

(0) Share

Report

Posted on by Ian-Murphy

I have a List in a SharePoint site that contains work orders and one of the fields is a Person object named Technician. I'm trying to build a flow so that when that Technician field changes, it sends a Teams message to the technician.

I tried to use the Switch function On Technician, but the cases only allow for text, so the comparison fails.

I know the Technician object has a property "DisplayName" that I can use for the comparison, but I can't figure out how to write that out.

I figure I'd have to put something like the following in the Switch On test: Technician.DisplayName, but can't figure out the correct format.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Ian-Murphy 27 on at

Like (0)

Report

I tried to delete this post, as I sort of figured this out.
I initially used the String(Technician DisplayName) function, which somehow changed into
string(triggerBody()?['Technician']?['DisplayName']) as I wrote it out. Later, upon saving the flow, it changed again to body('Get_item')?['Technician']?['DisplayName'] which somehow now worked, even though it was no longer converting it to a string?
No idea why the expression changed twice, or why it still works, but it does.
So, I no longer need any help getting it to work, but I'd certainly be interested in knowing why it works, now.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @Ian-Murphy ,

According to your third formula, I know that you used sharepoint's 'get item' action.

The action returns an object. (Object is a data type.)

The object has many properties, including ’Technician‘.

At the same time ,'Technician' is a person column. It also returns an object. The object contains a 'DisplayName' property.

So, If you have an object in flow and it has a column 'Test', you could use the formula like this:

Object?['Test']

You don't need to use string() function. Because the DisplayName of an object is a string already.

Best Regards,

Wearsky

Was this reply helpful? Yes No