web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Fetching the data from...
Power Automate
Unanswered

Fetching the data from dataverse based on the modified time and date

(0) ShareShare
ReportReport
Posted on by 31

Hello All,

I have a table in  dataverse, there would be multiple records whenever user done any changes to the record my bot should take it priority and execute that particular record and should go to another records.

I have a column modified , so based on that modified date and time it should pick the latest record as a priority.

can someone suggest me a perfect API query to get the data with modified date.

I have the same question (0)
  • CU16071609-1 Profile Picture
    6,255 Moderator on at

    @Vamsi_Envoy 

     

    Would you like to accomplish this using a Power Automate Desktop flow or a cloud flow?

     

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

     
  • Vamsi_Envoy Profile Picture
    31 on at

    Using Power Desktop flow in that i am using invoke web services to get the data from dataverse.

  • jt_benne Profile Picture
    2 on at

    Hi @Vamsi_Envoy 

     

    You can use use the $orderby query option in your API call.

    $orderby="modified datetime column name" desc

     

    Take a look at the following link: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api#order-rows

  • CU16071609-1 Profile Picture
    6,255 Moderator on at

    @Vamsi_Envoy 

     

    I'm still a bit confused. Why would you require a desktop flow here? Since your trigger point would be in Dataverse, you should set up the trigger point in a cloud flow only.

     

    First, you need to create an automated cloud flow with the highlighted trigger as shown below:

     

    Deenuji_0-1712248002849.png

    Then, the second step would be the Dataverse table configuration (where you can specify the data you want in the select columns area):

    Deenuji_1-1712248078128.png

    After that, you can use the desktop flow action below in case you need to interact with any Windows or on-premises application, or perform Windows-based automation or interact with a web application that lacks a web API.

    Deenuji_2-1712248206621.png

     

    And of course, it would require a premium license. If you don't have that, then this automation is not possible. Otherwise, you can create your RPA bot using the Invoke Web Service method where you can include some queries( https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api#order...), but again, it won't trigger unless you manually run it. Hope this helps.

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

     
  • Vamsi_Envoy Profile Picture
    31 on at

    My API Query:

    6 and ea_run_status eq 9 and ea_bot_name eq 'Stg_VM5' &$top=1& $orderby='modifiedon' desc
    While using the above query i am getting the error:
            "code": "0x80060888",
            "message": "The query parameter [REDACTED] is not supported"

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 273 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 149 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 144 Super User 2026 Season 2

Last 30 days Overall leaderboard