Creating child rows where foreign key is defined by Sharepoint Lookup column

[timm]

hi folks,

fairly new to powerapps, but have managed to create an app that displays a sharepoint list and drills down into a child sharepoint list (all the filtering to show only child rows is working fine).  The child sharepoint list has field, Project, that defines the relationship:

1) editing existing child rows works fine

2) creating new rows when at least one child row already exists work fine;

    this works because i can pass in a reference to the structure of the Sharepoint lookup column "Project", as follows:

       NewForm(edtIssueForm);Navigate(edtIssue, ScreenTransition.None,{prjRowNew: BrowseGallery2.Selected.Project})

   the editform receives the Project values for {@odata.type, ID, Value} and sets them correctly on the new edit form.  works great.

3) creating a new row if there aren't any existing child rows, i cannot figure out how to setup the Project lookup column structure and default values.  in the edit form, the dropdown works to select the Project value, but would rather not have to, since i know what the values of ID and Value are, but cannot set them and have been spending hours hacking at what seems like it should be pretty straightforward.

Can anyone help me understand how to create a new row with a defaulted value for the complex lookup type?  

Thank you

Can anyone point me in the right direction?

Thanks

[CJEales]

I am using PowerApps to create the parent record before adding the child record and using Flow to get the child's foreign key. This splits the two records into two screens in PowerApps, which is fine for my scenario.

Create a Flow starting from a PowerApps trigger (which you then add as an action in PowerApps). Flow can create a new item in a Sharepoint List, you just need to define the values of the fields. This can be done with dynamic values that are supplied from PowerApps. To define the foreign key though, you need to use a record, not a value (this is the problem with trying to do it in PowerApps).

To define the foreign key record you can use the "Get Item" action for Sharepoint lists in Flow to get the Parent record. You can then use the Primary Key from the Parent to define your foreign key in the child record.

In summary, use Flow to get the user defined values for your child record from PowerApps, at the same time as getting the foreign key record from the parent, and add it as a new item to a Sharepoint List.

I hope this is helpful.