Unanswered

Pre populate a form in power app

(0) Share

Report

Posted on by Matt951

Can someone please assist me in creating a sale order application using Power App? I have created two forms - one for taking sales orders and the other for viewing and editing the data entered in the first form. However, I have been unsuccessful in my attempts to complete the project using various methods.

Please someone should help me out

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

zuurg 546 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

How are you showing the 2 forms? NewForm(formname) for the taking of the order and EditForm(formname) for the viewing/editing part?

Was this reply helpful? Yes No
Matt951 5 on at

Like
a
(0)

Report
Copy link

Link copied!

@zuurg No, am using two different forms. Because the second column has more fields than the first one

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

That's fine, but how are you showing the forms?

Was this reply helpful? Yes No
Matt951 5 on at

Like
a
(0)

Report
Copy link

Link copied!

I attached the following formula to the Onselect property of the submit button:Navigate(SalesOrderFormScr, ScreenTransition.Cover, { SONumber: ThisItem }). And I addded the following formula to the field am using in the second form:Default: Param("SONumber").RFQ. Then I got the following error:Incompatible type. We can't evaluate your formula because the context variable types are incompatible with the types of value in other palces in your app.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Some screenshots would really help here. 🙂

A couple of things based on some assumptions I'm making from what you've provided:

The Param function will be text, not a number, even if the SONumber is a number. So if your datasource's SONumber data type is a number, you'll need to refer to it as Value(Param("SONumber")

Also, in my experience, instead of using ThisItem to refer to a record, I would explicitly do a LookUp of the record instead to make sure the schema stays the same: {SONumber: LookUp(dataname, ID=ThisItem.ID)}...

Although there's nothing wrong with using 2 different forms for the data entry & view/edit, you can always chose to hide fields on the NewForm based on the form's FormMode property: datacard.Visible: frmMyForm.Mode=FormMode.Edit || frmMyForm.Mode = FormMode.View will only show the data card if the form's mode is not New

Was this reply helpful? Yes No