Answered

using patch to insert record with 1:N relationship

(0) Share

Report

Posted on by isaac_sampaio

Hello, I have the following problem. I have two lists in sharepoint, one called tbUnit and another called tbStock.
In tbStock I have the following fields:
ID: autoincrement
Size: Text
Quantity: Number
UniformId: Number
Unit: Lookup (lookup on the ID field of the tbUnit table)
Unit:Name: "Unit Name"

In tbUnit I have the following fields:

ID: autoincrement
Name: Text

I'm trying to insert a record in tbStock with the following command:

Patch(tbEstoque;
 Defaults(tbEstoque);
 {
 Tamanho: txtTamanho.Selected.Nome;
 Quantidade: Value(txtQuantidade.Text);
 IdUniforme: Value(txtIdUniforme.Text);
 Unidade: {
 Value: txtUnidade.Selected.Nome;
 Id:LookUp( 
 tbUnidades; 
 Nome=txtUnidade.Selected.Nome
 ).ID
 }
 }
)

The above command is not generating an error, but the inserted record has a blank value in the field Unit of tbStock. Could you guide me why this error is occurring?

Thanks!

Categories:

Building Power Apps

Screenshot 2023-0...

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @isaac_sampaio ,

In your screenshot, I can only see a number in Unidade - if the Unidade:Nome beside it is a secondary lookup (please post a screenshot of your Lookup field setting), you cannot patch to them, in fact the whole Lookup column structure is generally unnecessary with Power Apps and will only cause you unwanted grief.

Was this reply helpful? Yes No
isaac_sampaio 7 on at

Like (0)

Report

Hi, @WarrenBelz, Below is the configuration image of the Unit field (lookup), as requested.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@isaac_sampaio ,

I suspected that - you only need to post the ID - you cannot post anything to the secondary lookup. Also I would not recommend that structure. If you must use lookup columns for something direct in SharePoint (I never have and most likely never will use them), display the actual Name column and then lookup the ID the way you have in your post.

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