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?
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.
Hi @paulsnolan ,
You need to provide Append/Append To permission to be able to use lookups.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.