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
@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.
Hi @jinivthakkar ,
Could you please share the screen capture of your flow. I'm fairly new to PowerAutomate to understand that you mentioned above
@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 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 - It apply the loop automatically.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
22 | |
21 | |
9 | |
8 | |
7 |
User | Count |
---|---|
33 | |
31 | |
24 | |
21 | |
11 |