cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Can you please help me with this error when I try to add a value in Body of the email?

I am trying to add an array field - List of certifications from the Item created above. When I try to add the value, Apply to each 3 automatically adds.

 

When I try to save it, I see this error. Please help!

 

GayathriSK_2-1600722878174.png

 

 

GayathriSK_1-1600722840052.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Using the get item:

danvarga_1-1601413003077.png

 

View solution in original post

8 REPLIES 8
ManishJain
Solution Sage
Solution Sage

Hi @Anonymous ,

 

This usually happens when you try to add value from the array. Can you please check the output of the item created in first step . 

 

Thanks

Pstork1
Dual Super User III
Dual Super User III

You can't add an array directly into an email.  What you have to do is process the array and convert it to an HTML table or a string before inserting it into the email.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hi @Anonymous 

 

@Pstork1 is a very good approach if you want to send an email with an array you can use the create HTML table and with the created array set the values.

Anonymous
Not applicable

can you help me create  HTML table for using one array variable in the email?

 

Anonymous
Not applicable

I tried creating Get Item and pulling in the array variable into email But the issue is I do not have the "Value" from get items to add in  Select function.

 

Should I need to use Get items instead of Get item?

 

GayathriSK_0-1601405438671.png

 

Hi @Anonymous 

 

You need to process all the records and create an array, then you can use the HTML table, looks like this:

 

danvarga_0-1601411996912.png

Finally you can use the HTML Table in an email:

danvarga_1-1601412029819.png

 

And this is the output:

danvarga_2-1601412070903.pngdanvarga_3-1601412104419.png

 

Anonymous
Not applicable

I am using the Get item instead of the Get Items function because I need only the item that was created in the flow. 

 

When I use this, I cannot find the array - Value to use it in the Select operation. Instead, I have body for which I get an error.

The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'.

 

GayathriSK_0-1601412533673.png

 

Using the get item:

danvarga_1-1601413003077.png

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,829)