cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShikhaJoshi
Frequent Visitor

Saving values from dataverse table in an Array.

Hello, 

I have a requirement where I need to save data from a dataverse table in an array for later use. I have an attachment field in my table , whose content also need to be stored in that array. Later I need to send a mail depending upon the other field value in that array. 

I tried creating an array with this option

ShikhaJoshi_0-1627496725934.png

 

I have got the result of this expression as 

ShikhaJoshi_1-1627496808358.png

 

but when I am trying to access the data from this array I am not getting this array in my dynamic content list. Also, I am not very sure that this approach is correct or not. 

Please advise. 

Thanks !!!

 

2 REPLIES 2
v-albai-msft
Community Support
Community Support

Hi @ShikhaJoshi ,

What do you mean about cannot get this array?

I did a test on my side using "Append to array variable" action and create array successfully(replace with your own attachment filed name): 

items('Apply_to_each')?['crea3_attachment1_name']

 

valbaimsft_0-1627548692322.png

Best regards,

Allen

ShikhaJoshi
Frequent Visitor

Thanks for the heads-up, but I am getting a template validation error. 

 

ShikhaJoshi_0-1627576131562.png

 

also if I get the array, how to extract the content based on the other two fields, like extracting value from a two-dimension array. 

Thanks a lot !!

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (3,256)