Answered

Power Automate Sharepoint Lookup Field Limitation

(0) Share

Report

Posted on by Ezander

Hello!

I'm receiving the dreaded Maximum Number of Lookup fields exceeded Error. this wouldn't be much of an issue but I'm unsure of what fields are technically considered Lookup fields outside of the obvious ones. Here is a list of fields I have present in the list.

Column Types:

Audience Targeting

Calculated (calculation based on other columns)

Hyperlink or Picture

Managed Metadata

Multiple lines of text

Person or Group

Publishing HTML

Publishing Image

Publishing Schedule End Date

Publishing Schedule Start Date

Summary Links

I know for sure that 'Managed Metadata' and 'Person or Group' are considered lookups.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Ezander,

I would say the Audience Targeting ones would also be counted. Don't forget about system fields like the Created By and Modified By, those will be included in the count as well.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report

You can send an HTTP request to the SharePoint list to see all of the fields. Look through the outputs to identify lookup columns.
They can be TypeAsString: "Lookup" which will help.

HTTP RequestRaw Outputs

Was this reply helpful? Yes No
Ezander 68 on at

Like (0)

Report

Hey there thank you for the reply! I I think works for me!

Was this reply helpful? Yes No
Ezander 68 on at

Like (0)

Report

Hey, Thank you for the reply! I'm inclined to agree with you. I was able to remove a couple 'person or group' fields and it got me under the limit.

Was this reply helpful? Yes No