I've enabled the PCF (Power Apps Grid) for a data table (say Table Company), which enabled me to use the view embedded (configured as List for Power pages) in a webpage, all other types of fields are editable in grid mode except for the Lookup Fields, I can confirm that I'm able to submit or update records using the insert form or edit form of the Company Table, so it means that I've the access to the lookup table.
Also in the Dynamics 365 settings of the table I've added the Lookup option as shown in the picture, I've also enabled the filter condition as well, even when I disabled it it did not work.
Is there any additional setting/configurations I'm missing ?
You're on the right track — editable Power Apps Grids in Power Pages can be tricky with lookup fields. The behavior you're describing is known, and there are a few key areas you need to verify or correct to get lookups working inside the editable grid view of a PCF-enabled list.
1. Ensure Lookup Field is Included in the View
2. Check Column Settings in Editable Grid Configuration
Go to the web page → List → Edit configuration
Select "Use Power Apps Grid"
In the column list, find your lookup field
Confirm "Editable" is enabled for it and “searchable”
Ensure the lookup is referencing a table that's visible to the web role
3. Security Role & Table Permissions for the Lookup Table
Add a new permission for the lookup target table (e.g., Account)
Enable:
Global or appropriate scope (Global is safe to test)
Read permission.
Link this permission to the Web Role
4. Make Sure Lookup Target Table is in Website Access Configuration
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
6
Share
Report
All responses (
Answers (
