Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / how to filter data ver...
Customer experience | Sales, Customer Insights,...
Suggested answer

how to filter data verse excel table to get last month dates

(0) ShareShare
ReportReport
Posted on by suman453535 5

Hi 

I was wondering if anyone could help me? I have created a power automate flow which retrieves a table from data verse. However I am trying to retrieve the dates from 3 months ago example i want all data that is in the month MARCH only. My table name is cuk_checkeddatatime. It currently brings every year. I only want the table to show 2023 in month march.

PLEASE HELP I HAVE TRIED EVERYTHING.

pastedimage1686051633763v2.png  

Below is list rows which retrieves the table i want from data verse, when they emails me all the data but i want to filter it too only email me march dates. 

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: how to filter data verse excel table to get last month dates

    Hi,

    If you want to fetch records on schedule basis where your flow will run every year and you only want data from current year and Month of March then you can do use below filter

    Createdon This year

    Created Month eq 3

    Created Month is a new custom field which will have month from created on field as Integer...you can use calculated field to extract month from created on and store in your custom field

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: how to filter data verse excel table to get last month dates

    Hi suman453535,

    Here is the idea of how to apply filters to your date column.

    For more details on how to use Fetch XML with retrieve list, you can visit this link.: Use lists of rows in flows - Power Automate | Microsoft Learn

  • suman453535 Profile Picture
    suman453535 5 on at
    RE: how to filter data verse excel table to get last month dates

    Thanks but can you advise what the query should be? I want all dates to show within march 2023? so what is the query for this?

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: how to filter data verse excel table to get last month dates

    Hi suman453535,

    After applying Fetch XML you are start getting your desired results, there is no need filter more.

  • suman453535 Profile Picture
    suman453535 5 on at
    RE: how to filter data verse excel table to get last month dates

    Hi

    I want to do this on Power automate? please is there a compose command or filter array command I can use to filter these dates?

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: how to filter data verse excel table to get last month dates

    Hi suman453535,

    User Xml Query option. Mak your desired quire from the query editor. Dowload that query and use it here.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans