Questions on using Select

(0) Share

Report

Posted on by annetoal

1,934 Moderator

I am trying to use Select to pull values out of a SharePoint get properties connector.

Here's the table:

1. I'd like to have another field named index but I need help with how to increment the value for that field.

2. I need help formatting the date fields to be d-MMM-yyyy.

I'd like to take the output from this Select and feed a Send mail connector. I'm using this expression:

output(body('Select')?['email'])

It's returning this error:

InvalidTemplate. Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '38868': 'The template language expression 'output(body('Select')?['email'])' cannot be evaluated because property 'email' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Could someone please show me what I'm doing wrong here and how to fix it?

Thank you,

Anne

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Pstork1 69,022 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The problem is that Data Select requires an array as input. Get File Properties returns an individual object with all the properties in it so you can't use it as input for a select. The individual properties are already available as dynamic content from the Get File Properties. You don't need to do anything to be able to use them.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!
@annetoal

To format date use below :

Expression:

formatdatetime(item()?['Modified'],'dd-MM-yyyy')

To use the output of the Select in an Email; you can use Create HTML Table as below:

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Pstork1 Yes, but there's so much stuff in that array that I don't need, I was trying to pare it down just to the fields that would be used in the Flow, hoping it would be easier to manage that way. I understand your point, and maybe it is making things more difficult than they should be.

Thanks,
Anne

Was this reply helpful? Yes No
Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I understand, but you can't use a select to do it and I don't know of any easy action to remove properties from a JSON object. They are all available by name now. I don't see any way to make it easier to manage

Was this reply helpful? Yes No