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

(0) Share

Report

Posted on by csteiner73

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 #	Model	Description	Price	Date Purchased
147852	12345	Dell Latitude	Dell Latitude 5430	1000	03/27/2023
147852	54321	Dell Latitude	Dell Latitude 5430	1000	03/27/2023
147852	67890	Dell Latitude	Dell Latitude 5430	1000	03/27/2023

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"

All responses (3)

Answers (1)

v-bofeng-msft on at

Like (1)

Report

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

Hi @csteiner73 ,

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

Best Regards,

Bof
csteiner73 24 on at

Like (0)

Report

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

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

v-bofeng-msft on at

Like (0)

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

Hi @csteiner73 ，

Please try:

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

Best Regards,

Bof