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.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!