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.
Thanks!
Proud to be a Flownaut!
Hi @rnunley
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:
I got it working. I used the "Switch" step in Power Automate along with a variable.
Hi,
That's great that you got it working! Remember to set as resolved for however helped you.
Regards,
Alex
-------
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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
58 | |
43 | |
38 | |
34 |
User | Count |
---|---|
91 | |
73 | |
72 | |
61 | |
41 |