How to get previous date in power automate

(0) Share

Report

Posted on by MB-08100221-0

Hi Community,

Currently I've already create a currency table where it gets live data from the exchange rate website but I wanted to show previous date exchange rates, can advise me on this?

I you want my flow I'll be happy to send it

Categories:

Process Advisor

I have the same question (0)

All responses (7)

Answers (0)

developerAJ 3,778 on at

Like (0)

Report

How to get previous date in power automate

Please share a screenshot of the formula you’re currently using along with details of your data source, so we can better understand your setup and how it’s currently configured.

Was this reply helpful? Yes No
André Arnaud de Cal... 171 on at

Like (1)

Report

How to get previous date in power automate

Hi,

We don't know what type of database you are using. In case the table can be called from a supported connector, and the connector supports filtering, you can use OData filters to select a specific date. Using a formula you can calculate the date of yesterday. Then you can retrieve the exchange rate for a specific currency at any given date.

Was this reply helpful? Yes No
MB-08100221-0 10 on at

Like (0)

Report

How to get previous date in power automate

Hi @André Arnaud de Calavon

I'm using an Open API

Was this reply helpful? Yes No
Suggested answer

chiaraalina 605 on at

Like (0)

Report

How to get previous date in power automate

Hi

You can use this expression:

formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd')

and then use the Compose Output in your OpenAPI Request.

Let me know if it helped!

Was this reply helpful? Yes No
MB-08100221-0 10 on at

Like (0)

Report

How to get previous date in power automate

Hi chiaraalina

My flow is like this, where should I put the compose action?

Screenshot 2025-1...

Was this reply helpful? Yes No
chiaraalina 605 on at

Like (0)

Report

How to get previous date in power automate

Hi

Add a Compose action right after your Recurrence trigger.

Use the following expression to return yesterday’s date (today − 1 day):

formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd')

This will output the previous date in yyyy-MM-dd format, for example: 2025-10-14.

You can then reference this Compose output in your HTTP action.

I’m not sure which API you’re using, but for example, if you’re calling the Exchange Rate API, your request URL could look like this:

https://api.exchangerate.host/@{outputs('Compose')}?base=EUR

Was this reply helpful? Yes No
MB-08100221-0 10 on at

Like (0)

Report

How to get previous date in power automate

Hi @chiaraalina

actually I want to show multiple rows with previous date

my API is this

https://api.bnm.gov.my/public/exchange-rate?session=0900&quote=rm

Was this reply helpful? Yes No