I have been using PowerApps almost 2 years now, and I have a issue that i cant solve and it gets placed on the back burner, then the issue will re-occur, I will work on it for a bit, and then the cycle continues. I have asked for help here before and I have been told more than once what I am trying to acheive is not possible. What is that?!! PowerApps can do anything......
Here is my issue:
I have a table (from Excel) with the first column as a date and values in the remianing columns. The date column in the Excel is set to a "Short Date" format. The remaining columns are "General Text." I have set the PowerApp to collect the tables "On Start". Within the app I have a "Service Date" from a date picker ( I also have a label for testing purposes) . What I need to happen is:
LookUp the StartDate from the colCuries and where it is = to the ServiceDate, then give me the value from the specific column of C1040 from the colCuries. My issue is the formatting is not the same and I cannot figure a way to correct this. Here is a screenshot of the information. The community has told me in the past this is not possible, I am hoping that over the past few months with the updates Power Apps has made, this is now possible and I am just not smart enough to figure it out. Any help with this would be greatly appreciated.
