Answered

max id in sql server table

(0) Share

Report

Posted on by Community Power Pla...

I'm simply trying to get the max ID in a sql server table....this is getting the lowest number?

Using a lookup to get one single record.

;
Patch(
        '[dbo].[t_nsc_trackcode_trans_time_entry_pa]',
         Defaults('[dbo].[t_nsc_trackcode_trans_time_entry_pa]'),
          {
           NSC_ID_Ref: LookUp('[dbo].[t_nsc_trackcode_assigned_dd_DataEntry_pa]',ID_Racfid = lbl_Racfid.Text ,Max(Value(NSC_Id))),
           opened_at: Now(),
           inprogress_or_closed_at: Now()
          }
                                   )
;

Thanks

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Please what are you trying to achieve with the Lookup and the max?

With Default in the Patch, are you adding new records?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@eka24, I forgot to add the table name reference to the formula.

NSC_ID_Ref: LookUp('[dbo].[assigned_DataEntry_pa]',ID_Racfid = lbl_Racfid.Text ,Max('[dbo].[t_nsc_trackcode_assigned_DataEntry_pa]',NSC_Id))

dave

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@Anonymous

This code returns only one Value since lookup is being used

LookUp('[dbo].[t_nsc_trackcode_assigned_dd_DataEntry_pa]',ID_Racfid = lbl_Racfid.Text ,Max(Value(NSC_Id)))

You might want to try FILTER instead to look at many values then get the MAX result

Max(Filter('[dbo].[t_nsc_trackcode_assigned_dd_DataEntry_pa]',ID_Racfid = lbl_Racfid.Text), Value(NSC_Id))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No