Why do I get "there's no records to display" when a try to create a new record in Power Pages form?
What I have configured:
1. The Power Pages form Data is set to "create a new record".
2. The Power Pages form is connected to the FormA in Dataverse
3. The FormA lookup field is from FormB in Dataverse
4. The FormA permission in Power Pages is set to "Create" and "Append" available to everyone. Then I set the child permission of FormA, the child permission is set about Form B permission in Power Pages is set to "Read" and "Append To" available to everyone.
5. The Lookup field has a quick view component (but this may not be the cause)
So now, it seems any user can access the page, the formA and formB, but just cannot see existing records created in formB.
It really appreciate if anyone know the possible cause.