cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshishJaiswal
Post Partisan
Post Partisan

Array to String source Excel

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 OneDriveExcel File on OneDrive

 

Logic of flowLogic of flow

 

ErrorError

 

 

7 REPLIES 7
jinivthakkar
Super User
Super User

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

 

jinivthakkar_0-1611230842787.png

 

jinivthakkar_1-1611230903245.png

 

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.

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
Super User
Super User

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

 

jinivthakkar_0-1611238624648.png

 

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

 

@jinivthakkar 

 

Getting Error,

 

Error2.jpg

jinivthakkar
Super User
Super User

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

Hi @jinivthakkar ,

 

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

@jinivthakkar ...Hi

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,444)