Unanswered

Relating two tables in Dataverse using Patch

(1) Share

Report

Posted on by Endjoy11

Hi,

I need to relate two dataverse tables. Table A and table B. I have a button in table A, which calls a dialog box (custom page). Inside this box there is a text field, which needs to update a column in table B. I have created a lookup column in table B. I guess I need to pass some kind of unique parameter from A to B, so that I can relate those tables. I tried with the Guid from A, but I cannot pass it to the lookup table as they do not match.

This is my code so far:

Patch('Consult Request Conversation Notes',Defaults('Consult Request Conversation Notes'),{'Notification Sent':TextBox1.Value, Completed: 'Completed (Consult Request Conversation Notes)'.Yes, 'Consult Request ID':GUID(VarRecordID)});
Back()

The code update the the bolded part is where i struggle, as I cannot pass a guid to a record.

I also used this video to create a custom page and the dialog box itself:

Power Apps Custom Pages & Power Fx - How to update Model-driven form from a custom page - YouTube

I am still a bit new to powerapps but any help will be appreciated.

thanks

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Endjoy11

Could you check if this might work better for you?
Relate and Unrelate functions in Power Apps
Endjoy11 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @poweractivate ,

thanks for the suggestion.
Maybe a silly question - how can I relate the ID of the first table with the ID of the second table with that function. Meaning when I access a record in table A, make sure that when the dialog box is filled it will relate the text/note (from table B) to this specific record. With the FIRST parameter I can update the first rows from both tables but that does not work for me. Maybe I need to do some kind of a match to make sure that the record ID I am accessing matches the GUID?
Endjoy11 56 on at

Like
a
(0)

Report
Copy link

Link copied!

any suggestions, how i can implement relate function to my specific scenario? It seems that in replaces patch function but still i cannot seem to relate the 1st and 2nd table.

thanks in advance.