Solved: Passing a value from a View Form to a New Form

Hello Power Apps Community,

Can you help please?

In a nutshell, I want to pass a GUID value from one form (Transaction) to another form (Transaction Line Item) only when the form Transaction Line Item is in FormMode.New. Any ideas please? Below is a more detailed explanation.

I have two Dataverse for Teams tables:

Transaction (which is the parent)

Transaction Line Item (which is the child)

So one Transaction can have many Transaction Line Items.

I have a screen Screen Edit Transaction

On this screen is a form frmEditTransaction this shows a Transaction record

Beneath the form I have another gallery galTransactionTransLineItem this shows all the Transaction Line Item records for the Transaction record in the form.

I can click on one of the Transaction Line Item records in the gallery galTransactionTransLineItem

This navigates to another screen Screen Edit Trans Line Item

And displays the clicked Transaction Line Item record in the form frmEditTransLineItem

The OnSelect property is

Set(

gblTransLineItem,

ThisItem

);

Navigate('Screen Edit Trans Line Item');

ViewForm(frmEditTransLineItem)

This works perfectly.

My request:

Now for my question please. On my screen Screen Edit Transaction (which has the Transaction form on it)

I have an icon. It's OnSelect property has the below formula on it.

Navigate('Screen Edit Trans Line Item');

NewForm(frmEditTransLineItem);

On the form frmEditTransLineItem where I'm creating a new Transaction Line Item, I have a lookup column called TransactionId to the Transaction table. How do I populate that column with the GUID from the Transaction table?

Thanks very much, and sorry for such a long description.

Garry

Categories:

Using Apps Using Formulas

General Questions