Approval - Time Format not changeable

[Kastore]

Hello everyone,

i am going nuts with my Approval workflow.. it is basically vacation-request workflow.

- Input from a MS.Forms

- copy inputs into tables

- Start and Await Approval: Worker A has requested a vacation from (Starting-Date) till (End-Date)

No matter what i am doing i don't get the dates in the form I want

Goal:
- dates in the European form of dd.MM.yyyy 

Attempts:

- Use the Excel dates -> format yyyy.MM.dd

- Use converted time dates -> format MM.dd.yyyy

- Use converted time (from gmt+1 to gmt+1) -> format MM.dd.yyyy

I really am lost for it right now and appreciate any help 😕 

Best wishes 

[MarvinBangert · Accepted solution]

Hey @Kastore 

did you tried using the expression "formatDateTime()" ? This should format the date to the format you are looking for:

Formular:

formatDateTime(outputs('Get_response_details')?['<Forms Question ID>'],'dd.MM.yyyy')

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel

[Kastore]

As of now i have not. I didnt now how to get the "form-answer" to be implemented in the expression (totally new to PA and flows.. this flow is the 3rd i am creating).

This works like a charm.