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.