Good afternoon!
I'm currently using the web version of Power Automate to capture responses from a Microsoft Form.
Everything looks good when it's parsed and entered into the XLS doc shown below:
From here, a Desktop Power Automate Flow is triggered that reads the content of this row and uses it to automate the creation of an account in a website.
On the surface, everything looks fine, however - when it's actually reading the data in Power Automate Desktop, the table shows that there is a time-stamp.
And of course, it's entering the date and the time into the website for the account creation. The website (an LMS) can't accept a time in the date field. I've tried formatting the data type in Excel to only show a short date. In Excel, it doesn't show the time-stamp. It only appears when Power Automate Desktop reads the XLS file and creates the table.
I'm not sure how to fix this. Has anyone encountered this issue before?
