Answered

SharePoint Get Items filter for Person/Group field not working

(0) Share

Report

Posted on by asatishrikant

Hello,

I am trying to implement a filter on a SharePoint list (field type: People or Group) using the getItems activity in Power Automate. This is giving an error as "One or more field types are not installed properly. Go to the list settings page to delete these fields.". I have even tried creating a new list with only 1 columns of the above type but still the same error.

Below is the filter.

ColumnName/DisplayName eq 'variablename'

Not sure if I am doing this correctly. Please help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

asatishrikant 13 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Found an alternative to do the filtering using email Id from the Odata instead of displayName: Below is the URL:
https://powerusers.microsoft.com/t5/Building-Flows/Can-you-filter-a-get-items-from-Sharepoint-list-by-Person-Group/m-p/516637

But still would any help pertaining to filters using displayName.

Thanks!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @asatishrikant ,

Unfortunately, if it is a person type field, as far as I know, we can only filter items based on email, and the person field does not allow multiple selections.

You could consider directly using Filter array to filter items.

Best Regards,

Was this reply helpful? Yes No
asatishrikant 13 on at

Like (0)

Report
Copy link

Link copied!

Will try this

Was this reply helpful? Yes No