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:

Business Process Flows

All responses (4)

Answers (1)

Ezander 68 on at

Like (0)

Report

Re: Power Automate Sharepoint Lookup Field Limitation

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.
Ezander 68 on at

Like (0)

Report

Re: Power Automate Sharepoint Lookup Field Limitation

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

wskinnermctc 6,517 Super User 2025 Season 1 on at

Like (0)

Report

Re: Power Automate Sharepoint Lookup Field Limitation

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
Expiscornovus 31,641 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate Sharepoint Lookup Field Limitation

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.