Power Automate - Community Question - Read Excel Column name with special characters

Power Automate - Community Question - Excel Column name with special characters
This video is based on a question from Power Automate Community Forum.
powerusers.microsoft.com/t5/B...

[@SiyamandRashid]

Thank you for the video

[@abm4975]

Thanks a lot

[@JakeerHussain-tk5uo]

Thanks for such a useful content

[@abm4975]

Glad it was helpful!

[@noodlebrains]

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

[@chaithunaidup30]

Create SharePoint Site Pages automatically with Power Automate when an item is added to OnPrem List i need this emergency can u anyone help

[@user-pi4pr6gq1y]

Can you please help me with the below implementation steps I need to extract the texts which contains _ in the email body

[@user-pi4pr6gq1y]

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

[@abm4975]

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

[@bhakti_krishann]

I want a flow to convert CSV file to Excel in power automate pls guide how to do this

[@abm4975]

There is a video already here by @damobird365 kzbin.info/www/bejne/b3uZhZuGjKyUfZI

[@bhakti_krishann]

@@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

[@abm4975]

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

[@bhakti_krishann]

@@abm4975 sorry cant use onedrive action as csv file is in SharePoint library

[@chaithunaidup30]

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