Array to String source Excel

[AshishJaiswal]

Hi Team,

I'm sending email from a using PowerAutomate, the source for this email is an Excel list.

Column 1 Contains list of email address (example - test1@test.com, test2@test.com, test3@test.com, test4@testcom)

When entering the values in the 'TO' filed in Send email connector I having issues - Please refer the screen capture

Logic of the flow

Pick up the details from excel and send email

Excel File on OneDrive

Logic of flow

Error

[jinivthakkar]

@AshishJaiswal you need to replace comma "," with semicolon ";" and then send the string to "To" field in email action

The expression I used to replace , with ;

replace(variables('varIDs'),',',';') /*replace comman with semicolon */

You will not be able to initialize variable inside the for each loop so, initialize variable at the start and then set them using expression inside the loop

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[AshishJaiswal]

Hi @jinivthakkar ,

Could you please share the screen capture of your flow. I'm fairly new to PowerAutomate to understand that you mentioned above

[jinivthakkar]

@AshishJaiswal I have hardcoded the values, you need to do it dynamically. Please check out few videos about Power Automate on YouTube and then try this.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[AshishJaiswal]

@jinivthakkar 

Getting Error,

[jinivthakkar]

@AshishJaiswal you cannot initialize variables inside for each loop, initialize before the loop and set in the loop. Keep the value as blank when you initialize.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[AshishJaiswal]

Hi @jinivthakkar ,

As soon as I enter the dynamic value 'List of owner' under initialize a variable - It apply the loop automatically.

[AshishJaiswal]

@jinivthakkar ...Hi