I have been trying to work out this using
Power Automate to list all sites in the site collection with the URL that contains at the end "ABC". I don't want to use names as it's not consistent.
I have tried using this:
But it doesn't return the right result. The documentation states query but what are the query options.
So if a site is
I want to filter sites that are like 'ABC' or contains 'ABC'.
Also the Get a site resource by path doesn't explain much.