I'm assuming the membership name is the same as the one presented in the email address. If so couldn't you use Split() to get the first entry in the email?
The email is is like belwo I think my pic is off..
I need to get to the "A27111" data.
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020