Get Last Record from CDS entity using PowerAutomate

[NigelP]

Hi

I have a CDS entity which contains membership number as one of its fields.
When a new member comes along I want to be able to calculate the next available membership number (Membership number := last Membership number + 1) in PowerAutomate.  I can do this in a SharePoint list but how is it done in CDS ?

Regards

Nigel