Hi @Madhavaraja
To try in power automate desktop, you have to utilize the powershell script as well
Use this code
SET doc_file TO $'''%''%'''
SET excel TO $'''%''%'''
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: excel Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow
Excel.ReadFromExcel.ReadCells Instance: ExcelInstance StartColumn: $'''A''' StartRow: 1 EndColumn: FirstFreeColumn - 1 EndRow: FirstFreeRow - 1 ReadAsText: False FirstLineIsHeader: False RangeValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstance
SET Final_String TO $'''%''%'''
Variables.CreateNewList List=> final_list
LOOP FOREACH row IN ExcelData
SET Final_String TO $'''\"%row[0]%\" +\" \"+ \"%row[1]%\"+\"`n\"+ \"a. %row[2]%\"+\"`n\"+\"b. %row[3]%\"+\"`n\"+\"c. %row[4]%\"'''
Variables.AddItemToList Item: Final_String List: final_list
END
Text.JoinText.JoinWithCustomDelimiter List: final_list CustomDelimiter: $'''+\"`n\"+\"`n\"+''' Result=> JoinedText
Scripting.RunPowershellScript Script: $'''# Create a new Word application object
$word = New-Object -ComObject Word.Application
# Make Word visible
$word.Visible = $true
# Create a new document
$doc = $word.Documents.Add()
# Get the content range of the document
$content = $doc.Content
# Write data to the document
$content.Text = %JoinedText%
# Save the document
$doc.SaveAs(\"%doc_file%\")
# Close the document
$doc.Close()
# Quit Word
$word.Quit()''' ScriptOutput=> PowershellOutput ScriptError=> ScriptError
specify the doc_file variable with word document path, excel variable with excel file path.
Results
Input excel
Output word file
If this answer helped you, Kindly mark this as solution so that others can be benifited.
Thanks & Regards,
Nived N
