Power Automate Get DriveId For Excel "Get tables"

Here i will show you how to get an Excel File from SharePoint dynamicaly

 

/_api/v2.1/drives?$select=id,webUrl&$filter=webUrl eq 'https://myTest/sites/Site1/doclib1'

body('Send_an_HTTP_request_to_SharePoint')['value'][0]['id']