web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch multiple values ...

Power Apps

Answered

Patch multiple values against same ID using Patch : Expected Number, found Table error

(0) Share

Report

Report

Posted on by pralikab931

18

I have a table called 'GroupDetails' , with Foreign Key as IM_No. I am using a collection to store the Ind_Id from a Gallery, as

Collect(IndinGroup, {Ind_Id: ThisItem.Ind_Id})

The table should look as follows. IM_No 1 already exists in the Master Table.

Ind_Id	IM_No
1	1
2	1
3	1

I am Using:

ForAll(IndinGroup,Patch('[dbo]..[Group_Details]',Defaults('[dbo].[Group_Details]'),{Ind_Id: IndinGroup[@Ind_Id], IM_No: Value(varIMRecord.IM_No)})

This gives me the error 'Expected Number for Ind_Id. Received Table'.

What am I doing wrong? Please help.

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pralikab931 ,
I am not sure this is the issue, but if you choose View > Collections > IndinGroup and can see a single value (not a table) in Indin_Id, the try this
ForAll( RenameColumns( IndinGroup, "Ind_Id", "IndID" ), Patch( '[dbo]..[Group_Details]', Defaults('[dbo].[Group_Details]'), { Ind_Id: IndID, IM_No: Value(varIMRecord.IM_No) } ) )

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.
pralikab931 18 on at

Like
a
(0)

Report
Copy link

Link copied!

It gives me a Foreign Key Conflict error. Insert statement conflicted with the Foreign Key Constraint. Ind_Id is also a foreign key here. I'm sorry I forgot to mention that.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pralikab931 ,
From what I understand, you you cannot Patch to that. Do you need to change it?

Join the conversation