To format the date correctly in your patch statement, you can use the Text function in PowerApps to convert the date to the desired format. Here's an example of how you can modify your patch statement to format the date as dd/mm/yyyy:
Patch(
ExcelTable,
{ ID: 1 }, // replace with the record ID you want to update
{ DateColumn: Text(SelectedDate, "dd/mm/yyyy") }
)
In this example, ExcelTable is the name of your Excel table, ID is the name of the primary key column in your table, DateColumn is the name of the date column you want to update, and SelectedDate is the date value you want to patch.
The Text function takes two arguments: the first is the value you want to convert to text (in this case, SelectedDate), and the second is the format you want to use. In the example above, we're using the "dd/mm/yyyy" format.
Note that if the date value in SelectedDate is null or blank, the Text function will return an empty string. If this is the case, you may want to handle it separately to avoid patching an empty string to your Excel table.
