Lookup EntraID group "Object Id" from group name

[antonlidblad]

What problem are you facing?

Some providers like dbforpostgresql.azure.upbound.io (FlexibleServerActiveDirectoryAdministrator) requires both principalName and objectId. To simplify I would like to lookup EntraID group objectId from group name.

I have tried to "observe" an existing EntraID group but annontation "crossplane.io/external-name" requires objectId (and not group name).

How can I lookup an EntraID group objectId from group name?

[vrabbi]

also very interested in this as part of some compositions we are working on. i would rather users supply names of groups and i will do the conversion in the backend which this can help support

[gravufo]

Very interested in this as well. Using our old architecture, we had a terraform script that would retrieve the group based on the group name in order to extract the objectId of the group for use down the line.
I am trying to rewrite that in crossplane, but it seems impossible due to this issue.
I think it should be supported since terraform also supports it as seen here:
https://registry.terraform.io/providers/hashicorp/azuread/latest/docs/data-sources/group#example-usage-by-group-display-name