cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShadowTech
Post Prodigy
Post Prodigy

Pre-populate a field based on another field in an edit form

Hello,

 

I'm looking to have field "A" populated with data from a SQL table when inputting a number in field "B". I'm working with two different data sources here. The main data source is a SharePoint list where the data from the Edit form will end up but pulling in data from the SQL table.

 

The formula works fine if I switch the mode to "New" but for what ever reason the "Edit" mode throws back an error.

 

If(
    EditForm.Mode = Edit,
    LookUp(
        SQLTable,
        SONumber = DataCardValue45.Text,
        TotalValue
    ),
    ThisItem.'Total Value'
)

 

Any suggestions on how to make this work?

 

Thanks in advance.

2 REPLIES 2
zmorek
Super User
Super User

Try

 

 

If(
    EditForm.Mode = FormMode.Edit,

 

 

Also with the below, are you comparing a number column to a text field? 

SONumber = DataCardValue45.Text,

@zmorek  To question (2), Yes. The SharePoint Field (ThisItem.'Total Value') is a currency field. How can I convert that?

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,207)