Parse json then interate through to get the next date

(0) Share

Report

Posted on by mikeosfa

Hi,

I have a flow I want to build to get the next uk bank holiday. The JSON file is https://www.gov.uk/bank-holidays.json.

Ideally I want to pass a variable from PVA where the user will either be in england-and-wales, scotland or northern-ireland.

The date field is a string. I want to convert the date field to a proper date, then I can use the do while to stop at the first date which is greater than (I have less than in the screen shot for testing) today (utcnow())

Can anyone point me in the right direction or offer another method?

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

annetoal 1,934 Moderator on at

Like (0)

Report

I thought you might find this interesting: https://collab365.com/calculating-weekends-weekdays-bank-holidays-uk-version-for-your-vacation-booking-app-using-power-apps-power-automate

Was this reply helpful? Yes No
mikeosfa 6 on at

Like (1)

Report

Thanks for your help with this one (and apologies, I thought I'd posted this earlier!) that managed to fix the issue

Was this reply helpful? Yes No