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 / Return a single value ...
Power Automate
Unanswered

Return a single value for a text field from an array of items

(0) ShareShare
ReportReport
Posted on by 24

I'm trying to create a flow that using something like the data below.  Basically a user enters a PO# on PowerApp and it launches this flow.  What I can't figure out is how to get it to populate one field for purchase date on my word template.  I use a variable for the date, it returns the date multiple times. If I just use the dynamic value for "Date Purchased", it corrupts the document.

 

Here's an example of how my data is structured in a SharePoint list:

PO#Serial #ModelDescriptionPrice Date Purchased
14785212345Dell LatitudeDell Latitude 5430100003/27/2023
14785254321Dell LatitudeDell Latitude 5430100003/27/2023
14785267890Dell LatitudeDell Latitude 5430100003/27/2023

 

csteiner73_0-1679937061529.png

csteiner73_1-1679937149064.png

 

The Array variable fills out a repeating table in my Word template, but on the template there's only a single place for the "Date Purchased"

 

csteiner73_2-1679938367284.png

 

 

 

 

 

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

    Hi @csteiner73 ï¼Œ

     

    Please try:

    outputs('Get_items')?['body/value'][0]['DatePurchased']

     

    Best Regards,

    Bof

  • csteiner73 Profile Picture
    24 on at

    That worked perfectly!  Thanks a ton.  So I understand, what does that expression do?

  • v-bofeng-msft Profile Picture
    on at

    Hi @csteiner73 ,

     

    This expression is to get the date value of the first item.

     

    Best Regards,

    Bof

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard