Power Platform Community Forum Thread Details

Hi,

I new to Power Apps and struggling with trying to insert multiple records into Azure SQL.

I have a table with idkey, ticket number, state, city, option 1 and option 2.

Idkey is autogenerated

Ticket number, state, city are prepopulated in the table

Option 1 and Option2 are dropdown based values

Using power apps I want to select multiple tickets and add a new row with value for option 1 and option 2 alongwith current timestamp.

I have been using below logic it inserts new rows

creating a collection to capture check box - this gets the ticket numbers

on select of btn "Insert records" patch function as below:

Patch(
myTicketTable,
Defaults(myTicketTable),
{
Option_1: drpdwn_Option_1.Selected.Result,
Option_2: drpdwn_Option_2.Selected.Result,
Timestamp: DateTimeValue(Text(Now(),"[$-en-US] mm/dd/yyyy hh:mm:ss")),
UserName: User().FullName,
EmailAddress: User().Email}
);