Entering row in excel via power automate

[Anonymous]

Hi,

So Here's my app,

I have an UI in power apps which calls a flow when clicking on submit button. The app sends 3 inputs to the flow, 2 text inputs and 1 input from date picker, which I formatted a bit using the Text() function.

My flow simply takes these inputs and appends to the excel table, which I connected to it, I did this cause using powerapps patch() function creates issues with locks when the excel file is opened by someone else.

The issue is with the date picker, the format I want is '10-Aug-21', 'Aug-21', or '10-08-21' but the cell in excel in always in the '10-08-2021 00:00:00' format, I checked the input and output of the flow component and its in the format I want but rows in the excel file always ends up being in this format of date and time. Can somebody tell me why this is happening?

[Nogueira1306]

Hey! In power autoamte you have some functions to format datetime

https://support.microsoft.com/en-us/topic/how-to-customize-format-date-and-time-values-in-a-flow-34a...