Create SP List item in 2 different lists using 1 button - ( 1st list is the 'Master' & 2nd List has lookup column to the 'Master')

(0) Share

Report

Posted on by Marty3012

Hi, I have the following code in the 'OnSelect' property of a button;

Patch(

'Master List',

{

Column1: ComboBox4.Selected,

Column2: ComboBox5.Selected,

ComponentName: TextInput_ComponentName.Text

}

);

Patch(

'Lookup List',

{

Column1: Label1.Text,

Column2: {Value: "TestValue"},

Column3: TextInput1.Text,

ComponentName: TextInput_ComponentName.Text

}

)

So I am patching (new item) in a list called 'Master List' and all columns are updated successfully.

Then I patch (new item) the second list 'Lookup List'. This list has a lookup column called 'ComponentName' that is related to the column 'ComponentName' in the Master List. The ComponentName in the Look Up list is the only column that is not updated and I think this is because the 2 Patches are run at the same time and the Look Up list ComponentName can't find its corresponding value in the Master List as it thinks it hasn't been created yet. Hope that makes sense.

Would anyone have an idea on how to correct this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Marty3012 ,

The Lookup column is making this far more complex than it needs to be (you may not have to use this column type - I never do. Try this

Patch( 'Master List', { Column1: ComboBox4.Selected, Column2: ComboBox5.Selected, ComponentName: TextInput_ComponentName.Text } ); Patch( 'Lookup List', { Column1: Label1.Text, Column2: {Value: "TestValue"}, Column3: TextInput1.Text, ComponentName: { Value: TextInput_ComponentName.Text, Id: LookUp( 'Master List', ComponentName = TextInput_ComponentName.Text ).ID } } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Marty3012 on at

Like (0)

Report
Copy link

Link copied!

Thanks, that works! Unfortunately the lookup column is required, but this solution does the job.

Was this reply helpful? Yes No