what is the formula to get a min date from the 20 date cells in POWER APP
Solved! Go to Solution.
Hi @dear406640,
Could you please tell me if you have these 20 dats within a single column?
Is it a SharePoint list?
Do you want to filter the min date from a record of date values?
If so, I think you could combine the Min() function with the Data Table control because the DataTable.Selected.Column could capture each item from a record.
Min(DataTable1.Selected.DateColumn1,DataTable1.Selected.DateColumn2,DataTable1.Selected.DateColumn3,...)
Hi @dear406640,
Could you please tell me if you have these 20 dats within a single column?
Is it a SharePoint list?
Do you want to filter the min date from a record of date values?
If so, I think you could combine the Min() function with the Data Table control because the DataTable.Selected.Column could capture each item from a record.
Min(DataTable1.Selected.DateColumn1,DataTable1.Selected.DateColumn2,DataTable1.Selected.DateColumn3,...)
WHAT IS THE FORMULA TO IGNORE A BLANK CELL WHEN WE FIND A MIN DATE ON POWER APP
User | Count |
---|---|
165 | |
90 | |
73 | |
64 | |
62 |
User | Count |
---|---|
211 | |
153 | |
96 | |
87 | |
66 |