Filtering results from the Select connector

(0) Share

Report

Posted on by Automate123

128

Hi Power Automate community,

I am currently working on a flow that is almost complete, however I need to make a few changes.

The flow itself basically calls Jira's REST API, from the JSON I use the Select connector to filter out results, and then put this data into a CSV file.

The issue I am having is related to the "Created" field. The JSON for this can be seen below:

"created": "2021-04-19T09:58:13.469+0100"

When I use the following expression on my Select connector:
item().fields.created

I extracted the correct value of:
2021-04-19T09:58:13.469+0100

However, if possible I would only like the date and time to be extracted. With the last 9 characters not needed. Also if possible to replace the T with a space to improve the format and readability. My desired outcome can be seen below:

2021-04-19 09:58:13

Is there something I could add to my expression, or modification I could make to my expression that would allow me to achieve this?

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

Hey Mate @Automate123

Please try the expression below -

formatDateTime(outputs('Compose'),'yyyy-MM-dd HH:mm:ss')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report

Hi @CFernandes

Thanks for a quick response. Could I ask where would I place these new connectors within my current flow?

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

Hey Mate,

Try to directly use it in the select action -

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report

Hi @CFernandes
Thanks for a quick response. My current Select expression for the "Created" field is:
item().fields.created

How would I incorporate your expression with my current, as I tried using the expression you provided however am getting errors.

Thanks

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

@Automate123 Parse JSON does not return you the Created field directly?

As a test add a "Compose" and show me the value of the Created field.

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report
Hi @CFernandes
Yes Parse JSON connector does return the created field.

When I add the expression you sent

formatDateTime(outputs('Compose'),'yyyy-MM-dd HH:mm:ss')

I am getting the following error.
In relation to you last comment, where would I add the Compose connector? Before the Select connector?

Is there not a way of achieving this just by modifying my current Select expression?
Thanks

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Let try the other way round -

Add the Compose action -

In the Compose action add the formula -

formatDateTime(<Created>,'yyyy-MM-dd HH:mm:ss')

Let me know if the that works.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report

Hi @CFernandes

I have added the Compose action as you suggested before my Select action.
I added the expression you gave into the input.

The Select expression for the Created field is set to the following:
item().fields.created

When I tested the flow, the output from the Created field was the same and had the unwanted characters.

Any ideas on how to achieve just a date and time format?

Thanks

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

Hey Mate,

It shows me -

Are you sure that you have passed in the output of the Compose action.

Was this reply helpful? Yes No
Automate123 128 on at

Like (0)

Report

Hi @CFernandes
Thank you for a quick response. I did not pass the output of the Compose action previously.

This is currently the Compose connector. It is just before the Select connector

When I add the output of the Compose action to the created field

output I get is the following:

Could I ask you to clarify what I should add to the Created field?
My previous expression of item().fields.created?
The output of the Compose action?
Both?

When adding both the results returned can be seen above.

Any ideas on how I could resolve this?

Thanks

Was this reply helpful? Yes No