web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ODATA Filter on Person...
Power Automate
Unanswered

ODATA Filter on Person field causes error: One or more field types are not installed properly.

(0) ShareShare
ReportReport
Posted on by 296

What I'm trying to do:

I have a list of training booked for technicians. As they travel to a global training centre, we try to book multiple courses back-to-back.

I'm trying to get a list of these trainings sorted by date and tech. So if a technician is going next week, he should be top of the heap but if he has more than one training, they should follow, rather than show further down the list. - Essentially I'm trying to group by technician (perCSE column).

 

My issue:

I create a list of unique emails and then run Get Items on each of these emails.

I'm doing this in other flows and it works just fine.

But for some reason in this flow I get the error: One or more field types are not installed properly.

 

perCSE is a Person field, it does not allow Groups or Multiple Selections.

Amapola188_1-1683864552055.png

 

This all looks as expected:

 

Amapola188_2-1683865066024.png

 

Note: As my end output, I don't want a table. I need too many columns and with the limited formatting for HTML tables, it just gets too ugly. My final output is meant to be text so I want to append the output to a string variable.

 

Giving up for now!

 

Thanks, Christine

 

 

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,189 Most Valuable Professional on at

    Hi @Amapola188,

     

    The person or group type of field has one gotcha. The EMail property needs to be written with a capital M.

    https://powerusers.microsoft.com/t5/Building-Flows/OData-Filter-Query-on-Person-Field/td-p/1763373

     

    Can you try

    perCSE/EMail eq 'yourvalue' 

     

  • Amapola188 Profile Picture
    296 on at

    @Expiscornovus 

     

    It's a true Gotcha, isn't it! Because I was even looking for that, capitalise Email ... I did not check on the M .. 

     

    Thanks so much!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard