Change user's display name in the HTML table in the email

[KCh]

Hi!

I'm trying to send the table of the tasks in the email.

Al works ok, but the field with the user (Assigned To) displayed in the email incorrect:

When I create the table I use following expression:

items('Применить_к_каждому')?['AssignedTo']

Could you please help me and advice how could I put only display name in the table?

Thanks!

[gamoraes]

Hi @KCh

You need to use this expression:

items('Применить_к_каждому')?['AssignedTo']?['DisplayName']

Best Regards

Gustavo Moraes

[KCh]

Hi @gamoraes!

Thank you!

I've tried to do this, but flow has an error in this way:

[gamoraes]

Hi @KCh 

All itens of apply to each have erros?

I dont understand Russian, but appears that some AssignedTo is null

[KCh]

Hi @gamoraes,

All items in the task list have the user in the field Assigned To.

In the flow all items have error.

The error is following:

The expressions in the template language can not be processed in the input data of the "Create" action in line "1" and column "2636": "It is impossible to calculate the expression of the template language" items ('Apply to each')? ['AssignedTo']? ['DisplayName'] " because you can not select the "DisplayName" property. You can select array elements only using an integer index. For usage details, see https://aka.ms/logicexpressions. ".

[KCh]

I see the interesting thing:

I've changed the field to "Author" in the flow and all work perfect.

So the problem is in the field AssignedTo.

I've checked once again in the task list - all items have users in this field.

Where could be a problem?

[gamoraes · Accepted solution]

Hi @KCh, 

I have an ideia, the field are multiple users?

try use this new expression, if work the field is multiple

items('Применить_к_каждому')?['AssignedTo'][0]?['DisplayName']

[KCh]

Hi @gamoraes!

Thank you!!!!! This is the Solution!

All work perfect now!

Thanks again!

[Anonymous]

Hi @gamoraes !

I'm having the same issue, cant get to show the name of the person, the fields name is "Person" but it looks like in the flow it's  called "Name" and I have tried with Name too but it doesnt work either, the difference with the case shown above is that I'm not using an "apply to each" action. What should I do?

The error:

The HTML table I'm receiving: