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.

Piotrt's avatar
Piotrt
New Member
4 years ago

This makes way more sense. Should have thought of this myself. Thanks.