In some clouds a resource can be automated even when name is specify Azure does this. How can I query to retrieve that name when I want to use it in another project Example a Managed Identity might name with auto naming and I need to capture that to link the MI to say data factory. How does one find out what name it was provided?

Sometimes you can use the name output on the resource, if there is one. There is no generic answer though, as many resources use different properties to store their name.