
Hi,
I'would like to make a selector of date from a excel.
Distinct(Tab_BI;Text(Date;DateTimeFormat.ShortDateTime;"fr-FR"))
there are no date read by powerapp.
I've tried to change the cell format in Excell, the only way is to tranform 09/12/2016 to '09/12/206 to enforce data.
hi @fabrice1 add another column to your excel sheet where the date has been converted to text = TEXT(cell,"mm/dd/yyyy") and powerapp will read that as text which you then convert to datevale(yourcolumn,"en-Us")
Give it a try, hope it helps