Hi, Hoping to get some help on my case here 🙂
I have a forms where i have a open text field - the users will use this one text field to write comments on three different topics (do not want to divide them into several questions because the topics might change). I want Powerautomate to automatically differentiate the text in this textfield based on a sign like : or starting with (...) and then creating cells in different columns (one column per topic) in a sharepoint online list or in excel. Any advice/help on how to set this up?
I have also looked at the text to columns in excel - but i dont know how you could do that action automatically.
Solved! Go to Solution.
@Anonymous , please configure your flow as follows:
1. Initialize variable of type string and assign it value from your form, here just for example I have assigned it a static value
2. Add compose action and copy following expression from dynamic content -> expressions and click on ok button
split(variables('text'),':')
3. Then add apply to each action and configure it as shown in below screenshot
You can use the split function to split as per the sign reference: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#s...
Let me know if you need further inputs on this
Thanks for the reply Annajhaveri, maybe i should have mentioned i am quite new to this - so i wouldnt know how to even put this function into my flow - like what "boxes" do i have to use (compose etc.). I have tried to google, but i am not finding the right resources. any idea of how i design it in powerautomate with this split option?
@Anonymous , please configure your flow as follows:
1. Initialize variable of type string and assign it value from your form, here just for example I have assigned it a static value
2. Add compose action and copy following expression from dynamic content -> expressions and click on ok button
split(variables('text'),':')
3. Then add apply to each action and configure it as shown in below screenshot
Hello, I know this is an old post but i am hopeful you will reply, I am having the same issue and have followed the steps you laid out but I feel like the last step is missing, I have initialized a variable as a string the value being the form response that needs to be split into multiple columns, done the compose step where I split the variables based on my chosen delimiter, and created an apply to each based on your steps, but how then do I take what I have split up and input it into separate columns of an excel table?
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
12 |
User | Count |
---|---|
128 | |
53 | |
38 | |
26 | |
21 |