Power automate Excel DriveId
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']
