I have a table called customerrProduct with read, append and appendTo privileges. I have a lookup in my power portal basic form. I rendered the lookup as a dropdown. Now my dropdown options are blank. I tried to read data from the table using fetchxml and liquid. I experienced the same problem retrieving the data from other columns returns the records but text is blank. Only the ID of the records can be retrieved(is not blank) but other fields text data returns blank. with my read and append privileges set to true. I don't know where the problem could be. I associated webrole to this entity permissions and also the user is associated to the appropriate webrole.
Any help regarding this issue i will highly appreciate.
Thank yu