I have an excel database as the source document for a power app. Folks can enter new data in the power app and it populates into the excel. Originally, the date field when entered in Power Apps passed through correctly in the format of mm/dd/yyyy.
Now if I try to view data in a power app gallery a numeric date such 45344 instead of 2/22/2024 displays. I thought it was an excel issue so I reformatted excel. The dates showed up correctly in excel but still not in Power App. I tried a few other methods but now the date is displaying numbers like 1706680800000 and 1709186400000.
Not sure, where I may have messed up. I’m still fairly new to Power Apps so troubleshooting isn’t my forte.
Below is the Patch function I’m using to tie two Power App forms together to pass data back to excel. Not sure if that is where the issue may lie.
T_EntryData is the table the information is submitted to
varFormData is a variable created so that in the gallery when you pull up data as either “view” or “edit” the individual forms display in either view or edit mode
BasicEntryForm first form screen that data is entered
TimelineEntryForm second form screen data is entered
ResultScreen is a screen after submission that allows user to choose if they want to create a new entry or go to the home page
