So I had originally worked with Dataverse as my connector to powerapps before switching to Sharepoint. One of the features I had used with Dataverse was within the default feature of my RichTextEditor tool, I was able to create an email format that pulled data from my Job Record (JR) table. The JR table contained two lookup columns one for the Candidate table and other for the Client table. So the email would be able to pull the data from the Candidate and client datacardvalue to get the appropriate information to input within the email being established.
The main feature I liked about how dataverse worked was that from the candidate/client datacardvalue I was also able to pull other column information from both tables for e.g. (As shown in the image. Those underlined blue are from the client lookup datacardvalue) I was able to pull the client address information from that one client lookup datacardvalue. So I'm wondering is this possible for sharepoint? I've only come to terms with the basics of how to use Sharepoint but I can't seem to be able to find a way to reciprocate the same method I used for dataverse on my sharepoint connected powerapps.
