You’re offline. This is a read only version of the page.
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
Share
ReportForAll('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.
Hi @Anonymous,
We could try and add a disambiguation operator, because it seems that the second table is simply not being recognized:
All responses (
Answers (
12,516
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!
