cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshishJaiswal
Super User
Super User

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
Dual Super User
Dual 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
Dual Super User
Dual 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
Dual Super User
Dual 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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,944)