Share
ReportHi,
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?
All responses (
Answers (
7,390
