Unanswered

Update Sequence Number in SQL Table

(0) Share

Report

Posted on by RussHaight

I have a pretty basic app to submit bids to an on-premise SQL server for aution items. The issue I'm having is updating the sequence number. I am using the following code:

Patch(Bids,Defaults(Bids),
{Item_Number:Value(subtxtItem.Text)};
{Bidder_ID:Value(BidderNumber.Text)};

{Amount_Bid:Value(SublblAmount.Text)};
{Maint_Userid:lblMaintID.Text};
{Maint_Date:Value(lblMaintDate.Text)};
{Create_Userid:lblCreateID.Text};
{Create_Date:Value(lblCreateDate.Text)};
)

The field for Seq_No would be between Bidder_ID and Amount_ID in the code?

The table is empty right now.

I have no idea what the code should be to submit to the Seq_no field in the table to increment by 1 for each submitted record.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@RussHaight

You can get the sequence number prior to submitting your record.

To get the most recent, utilize the following type of formula:

First(Sort(Bids, Seq_No, Descending)).Seq_No

If you happen to put this in a label (let's say) text property, it should show you the latest Seq_no.

Then your formula to submit your data would be:

Patch(Bids, Defaults(Bids), {Item_Number:Value(subtxtItem.Text), Bidder_ID:Value(BidderNumber.Text), Amount_Bid:Value(SublblAmount.Text), Maint_Userid:lblMaintID.Text, Maint_Date:Value(lblMaintDate.Text), Create_Userid:lblCreateID.Text, Create_Date:Value(lblCreateDate.Text), Seq_No: Value(yourLabel.Text) + 1 } )

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

RussHaight 29 on at

Like (1)

Report

That worked like a charm! thank you

Was this reply helpful? Yes No