Hi @Charline74
Sure you can use the split function.
split(<INSERT HERE THE FIELD>,'@')?[0]
You're fetching everything before the @ sign, so we split by that character and then get the first element of the array.
Cheers
Manuel
------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.
Hi @Charline74
Sure you can use the split function.
split(<INSERT HERE THE FIELD>,'@')?[0]
You're fetching everything before the @ sign, so we split by that character and then get the first element of the array.
Cheers
Manuel
------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.
Thank you for your answer, but where should I put this formula? Because I tried this:
it didn't work ?
Hi @Charline74
Almost there. Remove the "Reponser's email" and press "Dynamic content". There you can select the value and your formula will be correct.
Cheers
Manuel
------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.
Yes it works !
Thank you very much for your help 😊
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
12 | |
9 | |
9 | |
6 |
User | Count |
---|---|
25 | |
21 | |
17 | |
8 | |
8 |