Hello!
Can anyone help me figure out why a date isn't coming through in a date formula? Below are a couple screen shots that show my flow:
I'm using dynamic connectors to pull data from a table and insert it into the word template. in this case the Adj Start Date comes over as a random number instead of a date format. The column in the table is formated as a date, and the in the "List Rows Present in a Table" is set to Date Time Format.
I have tried to use the following expression instead of the dynamic connector under AdjHireDate, but when I added it, the flow stop populating the template all together:
Orignial (which pulled a random number but not the date)
I tried replacing it with (which stopped the flow from populated the template):
formatDateTime(items('apply_to_each')?['AdjHireDate'],'yyyy-MM-dd')
Below is an image of the parameters in the Populate a Word Template action:
Any ideas would be greatly appreciated!
