Forum Discussion

Piotrt's avatar
Piotrt
New Member
4 years ago
Solved

Formatting Dates

Hi,    I'm working on visualising a Sharepoint List right now, and my colleagues have made a PowerAutomate scrip that fills in this list. However it has it's flaws, where incorrect inputs still get...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Piotrt ,

     

    If you are using a sharepoint list then this should be done at the Power Query when you import the list to your model.

     

    Just filter out the values you don't want and then format has a date type.

PVO3's avatar
PVO3
Impactful Individual
4 years ago

Hi,

 

I would just change the date type in Power Query to date. All entries that can't be converted would get an error whick you can filter.