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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dataverse trigger not ...
Power Automate
Unanswered

Dataverse trigger not pulling correct data

(0) ShareShare
ReportReport
Posted on by 13
I am using the trigger When a row is added, modified or deleted for Dataverse.
 
Data is being pulled correctly but some of the data fields being pulled from Dataverse is either wrong or missing.
 
Examples:
End dates in CRM is 
End date in output
 
startdate (Beg Date): "2024-11-28T05:00:00Z"
ccenddate : "2024-11-28T05:00:00Z",
enddate : "2024-11-28T05:00:00Z",
 
 
 
Categories:
I have the same question (0)
  • Mark Nanneman Profile Picture
    991 Super User 2025 Season 2 on at
    Dataverse trigger not pulling correct data
    I see that your date times are all the exact same.  

    A.  Can you show a screenshot from a run of your flow showing the action that outputs the Dataverse Record's Date fields

    B.  And/or can you show a screenshot from your flow in editor, the part that displays "
    startdate (Beg Date): "2024-11-28T05:00:00Z"
    ccenddate : "2024-11-28T05:00:00Z",
    enddate : "2024-11-28T05:00:00Z",
     

    C.  Finally, can you confirm that in Dataverse these fields are set to be Date AND Time fields and not "Date Only"?

     
    If this reply helped you resolve the issue, please click "Does this answer your question" and give it a like to help others in the community (+ close the ticket)
    Power Platform Developer | LinkedIn: Mark Nanneman | Blog: Power Stuff  | Youtube: Mark's Power Stuff

     
  • AM-14112018-0 Profile Picture
    13 on at
    Dataverse trigger not pulling correct data
    Here is the output of the trigger
    "altai_exhibitorcount_date""2024-11-15T13:36:53Z",
      "altai_allocateceus"false,
      "psats_displayname""County Association of Township Officials Co. Convention - 11/28/2024   ",
      "_psats_cccoconventioninformation_value""386ec59e-56a3-ef11-8a69-7c1e520bb5f6",
      "_psats_cccoconventioninformation_value@Microsoft.Dynamics.CRM.lookuplogicalname""psats_coconventioninformation",
      "_psats_cccoconventioninformation_type""psats_coconventioninformations",
      "altai_attendeecount"0,
      "exchangerate"1,
      "psats_cclocation""PSATS",
      "altai_needvolunteer"false,
      "altai_createonlinemeeting"467670000,
      "_altai_createonlinemeeting_label""No",
      "altai_populatebadgeinformation"false,
      "psats_equipmentreturned"false,
      "altai_evt_eventstatus"2,
      "_altai_evt_eventstatus_label""In Progress",
      "psats_addtooutlookcalendar"false,
      "psats_flaggercertend""2027-11-28",
      "altai_showoncalendar"false,
      "psats_attendedcount"0,
      "_owningbusinessunit_value""69b87777-e1ba-e511-80dc-6c3be5a8fa14",
      "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname""businessunit",
      "_owningbusinessunit_type""businessunits",
      "altai_displayonwebsite"false,
      "altai_evt_eventtype"340970011,
      "_altai_evt_eventtype_label""County Event",
      "psats_equipspeaker"false,
      "psats_equipprojector"false,
      "psats_equiptable"false,
      "altai_startdate""2024-11-28T05:00:00Z",
      "psats_pendingcount_state"0,
      "_psats_cccountyassociation_value""a1a67ba9-9a8f-ea11-a811-000d3a4dfe21",
      "_psats_cccountyassociation_value@Microsoft.Dynamics.CRM.lookuplogicalname""account",
      "_psats_cccountyassociation_type""accounts",
      "psats_coursecompleted"false,
      "psats_capacityfull"false,
      "psats_cccontactemailaddress""amummert@psats.org",
      "psats_featured"false,
      "_ownerid_value""e7fb3d02-b2f2-e511-80e2-6c3be5a8fa14",
      "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname""systemuser",
      "_ownerid_type""systemusers",
      "_psats_county_value""7865523c-6b05-e611-80e0-c4346bac29f8",
      "_psats_county_value@Microsoft.Dynamics.CRM.lookuplogicalname""psats_pacounty",
      "_psats_county_type""psats_pacounties",
      "altai_template"false,
      "psats_isseo"false,
      "psats_ccanniversary""105",
      "altai_eventcode""County Convec",
      "psats_registrationcount_state"1,
      "psats_pmgapublicsafety"false,
      "altai_eventrevenue_state"1,
      "altai_istemplate"false,
      "psats_equipext_cord"false,
      "altai_sponsorcount"0,
      "psats_ccestattendance""10",
      "psats_eventwaitlistedattendeecount_date""2024-11-15T13:27:15Z",
      "altai_manualseteventtowaitlist"false,
      "psats_ccregistrationtime""9:00",
      "psats_attendedcount_state"1,
      "altai_evt_eventid""e972afa8-56a3-ef11-8a6a-000d3a53331c",
      "altai_templateclone"false,
      "timezoneruleversionnumber"0,
      "altai_allowcancellations"false,
      "statuscode"1,
      "_statuscode_label""In Process",
      "createdon""2024-11-15T13:36:53Z",
      "altai_eventrevenue"0,
      "psats_ccmeetingtime""3:00",
      "psats_classroombased"false,
      "psats_ccendtime""5:00",
      "altai_sponsorcount_date""2024-11-15T13:36:53Z",
      "psats_ccsetuptime""8:00",
      "psats_equipscreen"false,
      "psats_ccconventioncontact""Andrew",
      "psats_cleeligibleclasses"false,
      "psats_issolicitor"false,
      "altai_eventrevenue_date""2024-11-15T13:36:53Z",
      "psats_pmgaadministration"false,
      "psats_pmgaplanningzoning"false,
      "altai_attendeecount_date""2024-11-15T13:36:53Z",
      "psats_ccenddate""2024-11-28T05:00:00Z",
      "psats_registrationcount"0,
      "psats_pmgarequired"false,
      "altai_queueforregistrantimport"false,
      "psats_livewebinars"false,
      "modifiedon""2024-11-15T13:36:53Z",
      "altai_sendzoomconfemail"false,
      "psats_pmgapublicworks"false,
      "psats_ccdayofeventcontact""Andrew",
      "_transactioncurrencyid_value""6a162933-84c9-e511-80e1-6c3be5a8d808",
      "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname""transactioncurrency",
      "_transactioncurrencyid_type""transactioncurrencies",
      "psats_cclengthpsatsspeak""5",
      "altai_enddate""2024-11-28T05:00:00Z",
      "psats_cctimepsatsspeak""1:00",
      "_modifiedby_value""e7fb3d02-b2f2-e511-80e2-6c3be5a8fa14",
      "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname""systemuser",
      "_modifiedby_type""systemusers",
      "psats_cclocationaddress""4855 Woodland Drive",
      "psats_ondemand"false,
      "_createdby_value""e7fb3d02-b2f2-e511-80e2-6c3be5a8fa14",
      "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname""systemuser",
      "_createdby_type""systemusers",
      "psats_eventcertificationenddate""2027-11-28",
      "altai_evt_allowguests"false,
      "psats_seocourse"false,
      "altai_lmscourse"false,
      "psats_seminars"false,
      "altai_exhibitorcount"0,
      "altai_exhibitorcount_state"1,
      "altai_revenuerecognized"false,
      "psats_ccmealtime""1:00",  
      "psats_equiplaptop"false,
      "altai_sessionregistrationrequired"false,
      "psats_eventwaitlistedattendeecount_state"0,
      "statecode"0,
      "_statecode_label""Active",
      "altai_name""PSATS County Association of Township Officials Co. Convention - 11/28/2024   ",
      "psats_attendedcount_date""2024-11-15T13:36:53Z",
      "psats_moodleupload"false,
      "psats_virtualclassroomworkshops"false,
      "altai_retrievetransactionsfromeventapp"false,
      "altai_attendeecount_state"1,
      "psats_registrationcount_date""2024-11-15T13:36:53Z",
      "altai_sponsorcount_state"1,
      "altai_ticketed"false,
      "ItemInternalId""",
      "SdkMessage""Create",
      "RunAsSystemUserId""",
      "RowVersion"""
     
    And the column setting is set for Date and Time
  • Ellis Karim Profile Picture
    11,653 Super User 2025 Season 2 on at
    Dataverse trigger not pulling correct data
    Additional note: 
     
    Dataverse (and SharePoint) store dates in UTC (Coordinated Universal Time) regardless of the user’s local time zone or the App's region settings.
     
    In the date time value:
     
    2024-11-28T05:00:00Z
     
    the Z indicates that the time is in UTC time zone.
     
    See:
     
    Ellis
     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard