Answered

Expected Rrecord, Found Type Table.

(0) Share

Report

Posted on by Community Power Pla...

Hello,

This thread is resolve and junction documentation is missing on the web, community, youtube etc... so Enjoy reading for many to many custom relationship

I have 3 table, Idea --> 1:N --> Junction table <-- N:1 <-- Product

I have the following function :

ForAll(
cbIdea.SelectedItems,
Collect(
colideatopatchproduct,
{
Id: ThisRecord.ID,
Value: ThisRecord.Subject
}
)
);
ForAll(
cbproduct.SelectedItems,
Collect(
colProducttopatch,
{
Id: ThisRecord.ProductID,
Value: ThisRecord.Name

}
)
);

Patch(
Junction_Table_Idea_Products,
Defaults(Junction_Table_Idea_Products),
{
Name: "Test",
Product_L: colProducttopatch.Value
}
)

I'm getting an error that it is expecting a record and found a table, I tried adding .value or .Id still doesn't make a change...

Categories:

Building Power Apps

I have the same question (0)

All responses (27)

Answers (2)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Hey @Anonymous
which part has the error:

This last part jumps out to me so i am assuming it is here:

Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: colProducttopatch.Value } )

How many records are you getting in colProducttopatch is it more than one if so i am expecting that part to look more like:

ForAll(colProducttopatch As prodbeingpatched, Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: prodbeingpatched.Value } ) )

if your only expecting the one i was expecting to see something more like:

Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: First(colProducttopatch).Value } )
let me know how my suggestions go and if it doesn't work or i have misunderstood please do let me know 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@AJ_Z ,

I have multiple record, I added your code but still the same error.

ForAll(
colProducttopatch As prodbeingpatched,
Patch(
Junction_Table_Idea_Products,
{JunctionID: Blank()},
{
Name: "test",
Product_L: prodbeingpatched.Value
}
)
)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Here is the structure

Table Product 1:N Junction Table N:1 Table Idea

A Idea1
B Idea2
C Idea3

So when I enter my idea so let's say it is Idea number 3 and I select 3 product.

I want the junction table to be

Idea 3 - Product A
Idea 3 - Product B
Idea 3 - Product C

If I choose Idea 1 and select 2 product.

I want

Idea 1 A
Idea 1 B

with a table result :

A Idea1
B Idea1
A Idea3
B Idea3
C Idea3

** Obviously the choose of product is selected combo box and the idea will be a "text" called Subject of the Idea.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report

Okay thanks for this explanation 🙂 what type of column is Product_L is it Choice?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@AJ_Z

In junction table, it is the lookup to Product

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report

That is the problem. In my solution I incorrectly assumed it was text so only part of my solution works. I am going to retype up the same solution with a change. Before I do so, am i right in saying that all products have a unique name?
Also, what is the items property for: cbproduct
Does the Value column in the collection colProducttopatch correspond to the name of the Product in the sharepoint field? If that column corresponds to a unique field there we can use that to patch a lookup. I can show you what I mean once you are able to confirm the questions I have 🙂 .

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@AJ_Z

All Product should have a unique name yes. As of right now it is only text with an ID. ( But yes we are not suppose to have 2 product with the same name )

cbproduct :

I'm not using sharepoint but CDS ( Dataverse ) :

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report
Okay this might not be the final solution as i am making some assumptions but I am just updating the solution options as I gather more information:

Option One

ForAll( cbIdea.SelectedItems, Collect( colideatopatchproduct, { Id: ThisRecord.ID, Value: ThisRecord.Subject } ) ); ForAll( cbproduct.SelectedItems As cbprodselected, Collect( colProducttopatch, { Id: cbprodselected.ProductID, Value: cbprodselected.Name } ); Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: cbprodselected } ) );

Option 2

ForAll( cbIdea.SelectedItems, Collect( colideatopatchproduct, { Id: ThisRecord.ID, Value: ThisRecord.Subject } ) ); ForAll( cbproduct.SelectedItems As cbprodselected, Collect( colProducttopatch, { Id: cbprodselected.ProductID, Value: cbprodselected.Name } ); Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: LookUp(Products,ProductID= cbprodselected.ProductID) } ) );

If neither of these work it is likely either due to the names of the columns or the fact that I made an assumption that ProductID is the GUID for a record in the Products table which has been selected.

Also I am assuming that the reason we ForAll through colProducttopatch is just to patch the selecteditems that we have collected for some other purpose but if it is to patch from other sources in the app aswell it would need to look more like:

Option 3

ForAll( cbIdea.SelectedItems, Collect( colideatopatchproduct, { Id: ThisRecord.ID, Value: ThisRecord.Subject } ) ); ForAll( cbproduct.SelectedItems As cbprodselected, Collect( colProducttopatch, { Id: cbprodselected.ProductID, Value: cbprodselected.Name } ) ); ForAll( colProducttopatch As prodstopatch Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: LookUp(Products,ProductID= prodstopatch.Id) } ) );

if none of these scenarios are your one I would like a screenshot of the column names from the products table and from the juction table. I have ordered the options in most likely to be your scenario

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

So far the option 1 seems to be right on. I'll run some test around it.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Okay please run some tests and come back to me with any issues but so far the solution is:

ForAll( cbIdea.SelectedItems, Collect( colideatopatchproduct, { Id: ThisRecord.ID, Value: ThisRecord.Subject } ) ); ForAll( cbproduct.SelectedItems As cbprodselected, Collect( colProducttopatch, { Id: cbprodselected.ProductID, Value: cbprodselected.Name } ); Patch( Junction_Table_Idea_Products, Defaults(Junction_Table_Idea_Products), { Name: "Test", Product_L: cbprodselected } ) );
In your testing i want you to see if you already have many rows in the junction table relating to the same row in the product table. If you do test cbprodselected to see if there is anything weird and run this forall patch.

Was this reply helpful? Yes No