web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Update Sequence Number...

Power Apps

Answered

Update Sequence Number in SQL Table

(0) Share

Report

Report

Posted on by RussHaight

29

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 Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

That worked like a charm! thank you

Was this reply helpful? Yes No

Join the conversation