Power Automate - How to filter Excel date columns using ISO and Serial Number formats?

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 ธ.ค. 2024

ความคิดเห็น • 12

  • @MyRockMyFortress
    @MyRockMyFortress ปีที่แล้ว +1

    Thank You so much. I have been researching this since last Friday. I must have watched 20 hours worth of video in order to get the filter by today's date to work.

    • @abm4975
      @abm4975  ปีที่แล้ว

      Glad it was helpful!

  • @chikugerson5291
    @chikugerson5291 ปีที่แล้ว +1

    This worked for me many thanks.

    • @abm4975
      @abm4975  ปีที่แล้ว

      You're welcome!

  • @Nicolas.Gonzalez7
    @Nicolas.Gonzalez7 ปีที่แล้ว +1

    Thank you for the explanation, I'm trying to put all the result from the filter array in one single email, not in a apply to each, do you have any idea?

    • @abm4975
      @abm4975  10 หลายเดือนก่อน

      So once you had the array values use Select action step to map all the values want from the array. Then you could use Create HMTL table action step to map the values and finally map the output into the email action step.

  • @tundeoyegunsen9141
    @tundeoyegunsen9141 7 หลายเดือนก่อน +1

    Hi, does it matter if on the Excel I have a mix of dd/MM/yyyy and MM/dd/yyyy? Will it still work or do I have to fix it?

    • @abm4975
      @abm4975  6 หลายเดือนก่อน

      It need consistent format. Thanks

  • @adrianmoss4391
    @adrianmoss4391 ปีที่แล้ว +1

    Hi Looking to find away of showing only the last 7 days from the date Colum. any ideas?

    • @abm4975
      @abm4975  ปีที่แล้ว

      Hi
      Use the expression
      formatDateTime(addDays(utcNow(), -7),'yyyy-MM-dd') then compare with excel date less or not.
      Thanks

  • @ErwinSu-b4p
    @ErwinSu-b4p ปีที่แล้ว +1

    Thank you!!!

    • @abm4975
      @abm4975  ปีที่แล้ว

      You're welcome!