I am using MS Forms to collect data and Power Automate to send that data to an Excel Workbook. In the form I am collecting names as one of the fields. I would like the flow to convert their name to their initials and write the initials to Excel. There are only about six different names being input into the Form. Example: John Smith = JS, Amy Johnson = AJ. I tried using an IF expression but I cannot get that to work.
I have used the following flow with some expressions to solve what you want to achieve:
In this case, the field body('Get_response_details')?['r9723f014ffc146debd7eeca108b84ad0'] is the Forms field with the Name.
Here are the expressions used on each step:
1) Get the blank position between the first name and the last name:
That's great that you got it working! Remember to set as resolved for however helped you.
Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!