uploading bulk records

[BHR]

Hi All,

I need to implement the bulk upload functionality using power automate.

I have dataverse table which is having prefix and number columns.

Table1:
Prefix startnum
Inv 1001
Amz 1021

I have excel template which is having 1000 records .. I need to start the invoice num from Inv-1001(from the above table. ) as start number for the first record.. and based on the last inserted record (another table) invoice id i need to increment the + 1 for each record.

Can we acheive this kind of scenario using power automate. Can any one help me on this.

Thanks in advance