Recently I posted about the same issue. Yesterday I discovered a new way. It looks like OData connector is more friendly than the Web API one.
Use FetchXmlBuilder to help you to build the query.
Start creating you Dataflow:

For the data source on the tab Other pick up the OData connector.
For the Connection String URL will be like:
Continue Reading Olena Grischenko’s Article on their blog Recently I posted about the same issue. Yesterday I discovered a new way. It looks like OData connector is more friendly than the Web API one. Use FetchXmlBuilder to help you to build the query. Start creating you Dataflow: For the data source on the tab Other pick up the OData connector. Blog Syndicated with Olena Grischenko’s Permission
Dataflow for Power Apps: query CDS (improved)
More About This Author
Array
Power Automate10 August 2023Canvas App: Office365Users.Search UserV2 not working, but V1 does
Power Automate7 August 2023Co-pilot with Power Pages: new features to generate UI
YouTube7 August 2023Power Pages Copilot – YouTube
Power Automate19 July 2023Power Automate: Send approval email to external customer