web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Bulk insert to dataver...

Power Apps

Answered

Bulk insert to dataverse table using ForAll

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I need to insert multiple records to the table at once from the config table.
config table name: cs1_Config_Attestation_DE&OES

Target table name: cs1_Attestation_DE&OE_Data
Here is the function I have used in the onselect

ForAll('cs1_Config_Attestation_DE&OES',
 Patch('cs1_Attestation_DE&OE_Data',Defaults('cs1_Attestation_DE&OE_Data'),{
 
 AQDOID_AQID: "ABC"
 }
 );
)

I'm getting below error

column also exists in the table.
if I use patch function outside the ForAll, it works fine.

Appreciate if you could support for this issue.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

We could try and add a disambiguation operator, because it seems that the second table is simply not being recognized:

ForAll( 'cs1_Config_Attestation_DE&OES', Patch( [@'cs1_Attestation_DE&OE_Data'], Defaults([@'cs1_Attestation_DE&OE_Data']), { AQDOID_AQID: "ABC" } ); )

In order to further troubleshoot, you will have to take a look at the exact errors that you are receiving via the App Checker. (right of the Share button in the upper right corner - see formula errors)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No

Join the conversation