Populate NewForm() with Data from Variables

(0) Share

Report

Posted on by HiltonJE

Hello, I'm developing a simple App that allows for Purchase Requisitions.

The data consists of 2 tables. One is a header table, one is a details table.

I'm using SharePoint Lists as the data connection.

In order to keep the data in the Detail linked to the header I'm using a request ID.

I'm also using a combination if RequestID and LineItem together to create a unique row.

I'm trying to create a NewForm() and pre-populate it with the RequestID and LineItemID.

I'm able to set these values in a Variable using Collect() from the selected Detail table. I use the Request ID and then I look for the largest LineItemID and add 1.

I'm can not figure out how to add the Variable data to the newform.

I tried changing the Default Value, but when I do that it decouples it from the DataSource List.

NewForm(Detail_Edit);
Collect(
DetailRecord,
DataTable1.Selected
);
Set(
DetailRequestID,
DataTable1.Selected.RequestID
);
Set(
DetailLineNum,
LookUp(
SortByColumns(
Filter(
'B&G_Req_Detail',
NewReqID = RecordSelected
),
"field_1",
Descending
),
NewReqID = RecordSelected,
LineItemNum
)
);
Set(
DetailNextLineNum,
DetailLineNum + 1
);

From here I was hoping it would be as simple as something like....

Detail_Edit.LineNum.value = DetailNextLineNum

or Set(Detail_Edit.LineNum.value = DetailNextLineNum)

or something similar.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@HiltonJE

You cannot set a value of a control in PowerApps. PowerApps is modeled after Excel, so, just like in Excel you would not (from one cell) set another cell with something like B2="text", you would not do this in PowerApps either. Just like cells in Excel, you use Formulas on the properties of the controls to set them. So you would need to alter the appropriate property and provide a formula to reference the variable.

However, this is overcomplicated (your scenario) for PowerApps. It is much easier to do what you want.

First, you don't even need to create your own unique ID's. Your SharePoint list already has one...the ID column. Use that to connect your parent and child records.

The same applies to the child list...it has a Unique ID as well. So, trying to create your own is just extra work.

Now, the next piece of this is how are you doing your design? It was not entirely clear from your description.

Ideally, you would have a form that would deal with your parent (header) and then a gallery for your line items. You seem to indicate that perhaps you have a form for your line items?

Not sure entirely where you are with that part.

If you could expand on it a little (perhaps even a screenshot), that would be helpful.

Was this reply helpful? Yes No
HiltonJE 2 on at

Like (0)

Report

Randy, thank you for the guidance. Hopefully below I'm offering enough information, without being to verbose.
100% transparency, I am NOT a programmer. I am a network admin that is a script kiddie to get where I need to be and get myself into trouble.

My current "design" is a BrowseGallery with the HeaderTable Source.

When you click a record there it brings you to a DetailScreen with the HeaderTable Source. Also, when you click the Browsescreen record, it sets a RequestID Variable.
Navigate(DetailScreen1, ScreenTransition.None);
Collect(SelectedRecord,BrowseGallery1.Selected);
Set(RecordSelected,BrowseGallery1.Selected.RequestID)
From here you can Edit the Header record (this will eventually be home to workflow processing as well for approvals)

You can also click the Line Detail button which opens a Line Detail screen with a new datasource Req_Detail that contains line items of parts for order.
This page has two controls on it. A view table and a form.
When you click a record in the Table it open the form for editing of that record.
The table opens using the Variable set before at the header screen.
SortByColumns(Filter('B&G_Req_Detail',NewReqID=RecordSelected),"field_1",Ascending)
Form Data is set with:

When you click the New record button it calls the NewForm() function. I also create some Variables that were intended to set the Next Line number and requestID number, this was how I planned to tie the Header and Detail information together.
I also intended to add things like username, Now() and other default values to the Form.

NewForm(Detail_Edit);
Collect(
DetailRecord,
DataTable1.Selected
);
Set(
DetailRequestID,
DataTable1.Selected.RequestID
);
Set(
DetailLineNum,
LookUp(
SortByColumns(
Filter(
'B&G_Req_Detail',
NewReqID = RecordSelected
),
"field_1",
Descending
),
NewReqID = RecordSelected,
LineItemNum
)
);
Set(
DetailNextLineNum,
DetailLineNum + 1
);

Cancel button just calls the ResetForm() function.
Erase calls the Remove('B&G_Req_Detail',DataTable1.Selected) function.
Save calls the SubmitForm() function.

I'm having a hard time figuring out how I would link the header and detail data together without some sort of a key (unique id per Instance of Header, to detail.

Attached is the sample data I'm using.

BGPartsRequest.xlsx

Was this reply helpful? Yes No