retrieve Value from SQL Table using powerapp

Question

I have 3 form inside the screen which are

1. Period form It display a period

• (that table have a field 'aphid')

2. Activity form It display the Activity Sequence and Description

• (that table have a field 'actid')

3. Week Form

• I want to retrieve the value from this app_apWeek table using the key period form (app_apHead) and activity form(app_activity)

which select apwprogress from aphid ='some value' and actid ='somevalue'

sample code that can retrieve a value = select apwprogress from app_apweek where actID=235 and aphID =23

Summary : i want to retreive the apwProgress field from app_apweek table

I have some problem of retrieve value from multiple field. I am using Lookup but give an error on it.

LookUp(
    // Look for app_apWeek table
    app_apWeek,
    // Using apHead table(aphid) and activity table(actid) to look for the value
    app_apHead.aphID And app_activity.actID,
    // Replace the value to the textinput1 field
    TextInput1
    )

SQL table value

I not sure which part is wrong. Can suggest to me a better way to retrieve value. Thanks

Answer 1

I'm a little confused as to what exactly you are trying to do, but this should get you there.

Looking at the SQL statement...

SELECT * FROM <table_name> WHERE <column1> = 235 AND <column2> = 23

Here's one way to do this in PowerApps:

LookUp(TEST_TABLE,                    //SELECT the first record
    And(                              //WHERE, AND
        actID = Value(txtActID.Text), //column1 = txtActID.Text as INT
        aphID = Value(txtAphID.Text)  //column = txtAphID.Text as INT
    )
)

Where...

• actID and aphID are INT data types in SQL and...
• txtActID and txtAphID are Textbox controls in PowerApps

See it in action...

Things to remember:

• Using a LookUp here will only bring back the first record even though more records may meet the criteria
• Use the PowerApps Filter function instead if there are more than 1 record that meets the criteria