Expected Rrecord, Found Type Table.

[Anonymous]

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...

[AJ_Z]

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 🙂

[Anonymous]

@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
}
)
)

[Anonymous]

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.

[AJ_Z]

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

[Anonymous]

@AJ_Z 

In junction table, it is the lookup to Product

[AJ_Z]

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 🙂 .

[Anonymous]

@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 ) :

[AJ_Z]

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

[Anonymous]

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