Change a date as text (STRING) to a date format (DATE) with Power Automate

If you receive a date as a STRINGA string is a data type that contains a character string. Detailed information is available here: https://www.inf.hs-flensburg.de/lang/prog/string.htm#:~:text=Strings%20sind%20Objekte,ein%20Objekt%20der%20Klasse%20String. in a flow, the conversion process is not easy, but can be solved as follows:

1. Create STRINGA string is a data type that contains a character string. Detailed information is available here: https://www.inf.hs-flensburg.de/lang/prog/string.htm#:~:text=Strings%20sind%20Objekte,ein%20Objekt%20der%20Klasse%20String. variable (here as an example a contract start from an Excel file)
2. Splitting of day, month and year: split(outputs(‘contract_start_STRING’), ‘.’)
3. Create variable for the tag: first(outputs(‘Contract startSPLIT’))
4. Create variable for the month: first(skip(outputs(‘Contract startSPLIT’), 1))
5. Create variable for the year: first(skip(outputs(‘Contract startSPLIT’), 2))
6. Merge into a date format: @{variables(‘month’)}/@{variables(‘day’)}/@{variables(‘year’)} 00:00:00Z

Dieser Beitrag ist auch verfügbar auf: Deutsch (German)