cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vjnvinod
Frequent Visitor

office365 formula error

hi,

 

I have some issues with this formula below

is there any way I can fix it?

 

vjnvinod_0-1642427032419.png

 

as i result I am getting the below error in play mode

 

vjnvinod_1-1642427391937.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Super User
Super User

When I had that problem I did this:

 

If(!IsBlank(ThisItem.'Created by'.DisplayName);Office365Users.UserPhoto(ThisItem.'Creaeted by'.Email);SampleImage)

 

And the error stopped. You can try this:

 

If(!IsBlank(ThisItem.'EP Email ID');Office365Users.UserPhoto(ThisItem.'EP Email ID');SampleImage)

 

IF that field is a person field dont forget to put something like .Mail or .ID on the end.

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

View solution in original post

2 REPLIES 2
Nogueira1306
Super User
Super User

When I had that problem I did this:

 

If(!IsBlank(ThisItem.'Created by'.DisplayName);Office365Users.UserPhoto(ThisItem.'Creaeted by'.Email);SampleImage)

 

And the error stopped. You can try this:

 

If(!IsBlank(ThisItem.'EP Email ID');Office365Users.UserPhoto(ThisItem.'EP Email ID');SampleImage)

 

IF that field is a person field dont forget to put something like .Mail or .ID on the end.

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

vjnvinod
Frequent Visitor

@Nogueira1306 

 

Awesome worked like a charm, thanks so much

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,757)