Hi All
Is it possible to get the email address associated to a DL group in flow?
I know Microsoft and the Power Platform (for whatever reason) have blocked the use of DL groups in the "to" field of send emails but a bunch of people have come up with workarounds which all in all, are just using the email of the DL group to send to (works a treat, can confirm). Now a question I'm sure you'll ask is "well why not just use the email instead of the DL name". Well I can't force the business to just start using emails instead of DL groups for this particular flow so I've gotta come up with some sort of workaround.
I've managed to build a flow that'll put the DL group name into a formatted string (from a SP text Datasource), but now I need to see if there is a way to get the email of that DL group on the fly so I can then use it to send the email to. I can't find any reference to what I'm after on google so hopefully someone may have a workaround.
I don't have access to premium connectors so hopefully there is a 'pleb level' connector that'll do the job.
Thanks in advance!
