Table look up not behaving as expected

what am i doing wrong

Dear @ppe_office,

Welcome to the community :handshake:

Please could you be more specific where you see something going wrong?

in contacts table , consultation column, row #6 date format has changed.

Dear @ppe_office

In the consultation table the column “type consult” should contain the following formula:

Concatenate(Format("{1} {2}, {3}", thisRow.[date of consult].MonthName(), thisRow.[date of consult].Day(), thisRow.[date of consult].Year()), "  " ,thisRow.contacts)

The formula “format” is assuring that the layout is consequent executed in the way you write in the syntax.

This is the source where I have learned it in the past:

1 Like

thank you love it button