Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Portal entity form with lookup fields gets permission error when submitting

Hi All


I have a portal page that uses an entity form for entity xyz. The form contains a number of fields including two lookup fields (Supplier, Framework). When the page/form is submitted I get the message



                The form could not be submitted for the following reasons:

                You don't have the appropriate permissions.



If I remove both the lookup fields from the entity form (entity/table permissions is enabled) the data is submitted and a new xyz entity record is created (with empty Supplier and Framework fields)


Also if I leave both lookup fields on the form but disable entity/table permissions on the portal page the data is submitted and a new xyz entity record is created which includes the values selected in the lookups.


So it looks like I have an entity permission issue with the lookup fields. I've tried creating an entity permission for Framework with a Global scope with Read, Write and Create privileges and including that lookup on the form but I get the same error message. What is required to be able to create an entity record where the source of one or more of the fields is a lookup on a portal age?



Frequent Visitor

I assume you have also provided web roles to the entity permissions. Either a specific role or anonymous access. I would expect it to behave like the way you described if the correct web role is not assigned.

Hope this helps.

Super User
Super User

Hi @paulsnolan ,


You need to provide Append/Append To permission to be able to use lookups.

If you find this post helpful consider marking it as a solution to help others find it.
Frequent Visitor

Spot on. I missed that append / append to had not been given.

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,111)