I have one spreadsheet with a list of products (product 1, 2, 3) questions about the features, and then scores & comments for each feature. I wanted to set up a power automate to copy the scores for product 1 by reviewer 1 into another workbook in the sheet called product 1 and then same into the sheet called product 2. So there is individual sheets. It would then run each time a new feedback spreadsheet is received and copy over the scores to the product 1 worksheets in the next column to the scores from the 1st reviewer. Same process for the feedback. Is this possible
Tried below steps Got it. Here are the clear steps to achieve that: 1. Action: Compose • Add a “Compose” action to your flow. • In the “Inputs” field, use the expression split(body('HTML_to_text'), ' '). This will split the email body text into an array of words. 2. Action: Filter array • Add a “Filter array” action after the “Compose” action. • In the “From” field, select the output of the previous “Compose” action. • In the “Filter” field, use the expression contains(item(), '_'). This will filter the array to only include words that contain an underscore. 3. Action: Join • Add a “Join” action after the “Filter array” action. • In the “From” field, select the output of the “Filter array” action. • In the “Join with” field, enter a space or any other separator you prefer. Which is not outputting the exact texts
Create SharePoint Site Pages automatically with Power Automate when an item is added to sharepoint List i need this an emergency can u anyone help this
Thanks for such a useful content
Glad it was helpful!
Thank you for the video
Thanks a lot
I have one spreadsheet with a list of products (product 1, 2, 3) questions about the features, and then scores & comments for each feature. I wanted to set up a power automate to copy the scores for product 1 by reviewer 1 into another workbook in the sheet called product 1 and then same into the sheet called product 2. So there is individual sheets. It would then run each time a new feedback spreadsheet is received and copy over the scores to the product 1 worksheets in the next column to the scores from the 1st reviewer. Same process for the feedback. Is this possible
Can you please help me with the below implementation steps
I need to extract the texts which contains _ in the email body
Tried below steps
Got it. Here are the clear steps to achieve that:
1. Action: Compose
• Add a “Compose” action to your flow.
• In the “Inputs” field, use the expression split(body('HTML_to_text'), ' '). This will split the email body text into an array of words.
2. Action: Filter array
• Add a “Filter array” action after the “Compose” action.
• In the “From” field, select the output of the previous “Compose” action.
• In the “Filter” field, use the expression contains(item(), '_'). This will filter the array to only include words that contain an underscore.
3. Action: Join
• Add a “Join” action after the “Filter array” action.
• In the “From” field, select the output of the “Filter array” action.
• In the “Join with” field, enter a space or any other separator you prefer.
Which is not outputting the exact texts
I need to see this flow to determine what's wrong? I could offer a screenshare. Check my channel about section and contact me.
Thanks
I want a flow to convert CSV file to Excel in power automate pls guide how to do this
There is a video already here by @damobird365
ua-cam.com/video/9J6ThPWGaG0/v-deo.html
@@abm4975 yes available but I don't want to use run script or any other paid plugin... Is it any simple way to convert CSV to excel in power automate
Hi
One drive connector has an action step called 'Move or rename a file'. Try renaming the file from .csv to .xlsx. That might work.
Thanks
@@abm4975 sorry cant use onedrive action as csv file is in SharePoint library
Create SharePoint Site Pages automatically with Power Automate when an item is added to OnPrem List
i need this emergency can u anyone help
Create SharePoint Site Pages automatically with Power Automate when an item is added to sharepoint List
i need this an emergency can u anyone help this