web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Saving values from dat...
Power Automate
Unanswered

Saving values from dataverse table in an Array.

(0) ShareShare
ReportReport
Posted on by 8

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

 

Categories:
I have the same question (0)
  • v-albai-msft Profile Picture
    on at

    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 Profile Picture
    8 on at

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard