Hi all,
Apologies in advance if this has already been discussed; I've been looking through the forums for the past hour for a solution but no luck so far!
I'm trying to patch a gallery to a SQL table, however my patch command seems to be incorrect. This is my current code:
ForAll(
Collection,
Patch(
SQLTable,
{
UserName: gUsername.Text,
IBAN: gIBAN.Text,
Bank: gBank.Text,
Currency: gCurrency.Text,
Mandate: gMandate.Text,
UserRole: gUserRole.Text,
Limit: Value(gLimit.Text),
Note: gNotes.Text,
RequestedBy: User().FullName,
DateRequested: Now()
}
)
)
The command is patching the correct number of records into the SQL Table, (As the number of records in the collection can vary based on a user's requirement), however row in SQL has the same details. It appears as though the first record in my collection is being read but all subsequent rows are just repeating the details of the first record. For example, my command will create two records for the below in SQL, however the second record's data will just be a duplicate of the first:
Curious as to whether anyone else has had this problem? I'm new to PowerApps so suspect it's a silly mistake on my end but any help with this would be greatly appreciated!
Many thanks,
Miles.
