Hello Community,
I am trying to get records from Flow to PowerApps from CRM.
So I have created Flow, filtered data of Dynamics 365 in flow and passing that data to PowerApps using Respond to PowerApps.
Calling flow from PowerApps and getting result in PowerApps but not able to access collection data which came from PowerApps.
ClearCollect(dataCRM,GetdatafromDynamicsCRM.Run(User().Email))
In PowerApps I am getting error:
Can anyone tell me what I have to set in response step of Flow to get proper data from Flow to PowerApps ?
Hi @rajmilansinh ,
Do you want to pass records from flow to your app?
Could you please share a bit more about the dataCRM collection data after you execute the GetdatafromDynamicsCRM.Run() formula within your app?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
The flow's configuration as below:
The App's configuration as below:
The result returned from the the ClearCollect(dataCRM, GetdatafromDynamicsCRM.Run(TextInput1.Text)) formula as below:
Please check if your dataCRM collection is populated with proper records as above.
In addition, within the "Response Body JSON Schema" filed of the "Response" action in your flow, if the JSON playload you typed looks like below:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.id": {
"type": "string"
},
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"crba2_taskname": {
"type": "string"
},
"_owningbusinessunit_value": {
"type": "string"
},
"_owningbusinessunit_type": {
"type": "string"
},
"crba2_previewcount": {
"type": "integer"
},
"crba2_primaryname": {
"type": "string"
},
"crba2_duedate": {
"type": "string"
},
"statecode": {
"type": "integer"
},
"_statecode_label": {
"type": "string"
},
"statuscode": {
"type": "integer"
},
"_statuscode_label": {
"type": "string"
},
"_createdby_value": {
"type": "string"
},
"_createdby_type": {
"type": "string"
},
"timezoneruleversionnumber": {
"type": "integer"
},
"_ownerid_value": {
"type": "string"
},
"_ownerid_type": {
"type": "string"
},
"modifiedon": {
"type": "string"
},
"crba2_approvalstatus": {
"type": "integer"
},
"_crba2_approvalstatus_label": {
"type": "string"
},
"_modifiedby_value": {
"type": "string"
},
"_modifiedby_type": {
"type": "string"
},
"versionnumber": {
"type": "integer"
},
"crba2_tasklistsid": {
"type": "string"
},
"createdon": {
"type": "string"
},
"crba2_multistatus": {},
"_modifiedonbehalfby_value": {},
"crba2_isoverdue": {},
"crba2_register": {},
"crba2_registerdate": {},
"overriddencreatedon": {},
"utcconversiontimezonecode": {},
"_createdonbehalfby_value": {},
"_owningteam_value": {},
"crba2_currentlanguage": {},
"_crba2_customer_value": {},
"importsequencenumber": {}
},
"required": [
"@@odata.id",
"@@odata.etag",
"ItemInternalId",
"crba2_taskname",
"_owningbusinessunit_value",
"_owningbusinessunit_type",
"crba2_previewcount",
"crba2_primaryname",
"crba2_duedate",
"statecode",
"_statecode_label",
"statuscode",
"_statuscode_label",
"_createdby_value",
"_createdby_type",
"timezoneruleversionnumber",
"_ownerid_value",
"_ownerid_type",
"modifiedon",
"crba2_approvalstatus",
"_crba2_approvalstatus_label",
"_modifiedby_value",
"_modifiedby_type",
"versionnumber",
"crba2_tasklistsid",
"createdon",
"crba2_multistatus"
"_modifiedonbehalfby_value",
"crba2_isoverdue",
"crba2_register",
"crba2_registerdate",
"overriddencreatedon",
"utcconversiontimezonecode",
"_createdonbehalfby_value",
"_owningteam_value",
"crba2_currentlanguage",
"_crba2_customer_value",
"importsequencenumber"
]
}
}
please remove these fields which have not been assigned with a proper type value (e.g. "type": "string" ) from the properties part and the required part. On my side, we need to remove these fields which marked as Red as above from the Playload value.
Please check and see if the following blog would help in your scenario:
https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/
Please consider re-create/re-configure your flow, then create the flow connection within your app, then try your formula again, check if the issue is solved.
Best regards,
Hello @v-xida-msft ,
thanks for the details but I am getting wrong data in collection shown below:
And my response json in Flow is as below
{
"type": "object",
"properties": {
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"msdyn_allowoverlapping": {
"type": "boolean"
},
"indusa_verified": {
"type": "boolean"
},
"exchangerate": {
"type": "integer"
},
"indusa_resourceemailid": {
"type": "string"
},
"endtime": {
"type": "string"
},
"bookingtype": {
"type": "integer"
},
"_bookingtype_label": {
"type": "string"
},
"_resource_value": {
"type": "string"
},
"_resource_type": {
"type": "string"
},
"name": {
"type": "string"
},
"indusa_iscreatedupdatedflag": {
"type": "boolean"
},
"_owningbusinessunit_value": {
"type": "string"
},
"_owningbusinessunit_type": {
"type": "string"
},
"_indusa_createdbycustom_value": {
"type": "string"
},
"_indusa_createdbycustom_type": {
"type": "string"
},
"indusa_customer": {
"type": "string"
},
"importsequencenumber": {
"type": "integer"
},
"_ownerid_value": {
"type": "string"
},
"_ownerid_type": {
"type": "string"
},
"indusa_nextdate": {
"type": "string"
},
"bookableresourcebookingid": {
"type": "string"
},
"_indusa_currentresidenthh_value": {
"type": "string"
},
"_indusa_currentresidenthh_type": {
"type": "string"
},
"msdyn_cascadecrewchanges": {
"type": "boolean"
},
"_indusa_championbookingtype_value": {
"type": "string"
},
"_indusa_championbookingtype_type": {
"type": "string"
},
"indusa_ismodified": {
"type": "boolean"
},
"indusa_willyoufollow": {
"type": "boolean"
},
"msdyn_bookingmethod": {
"type": "integer"
},
"_msdyn_bookingmethod_label": {
"type": "string"
},
"timezoneruleversionnumber": {
"type": "integer"
},
"statuscode": {
"type": "integer"
},
"_statuscode_label": {
"type": "string"
},
"createdon": {
"type": "string"
},
"msdyn_traveltimerescheduling": {
"type": "boolean"
},
"msdyn_estimatedarrivaltime": {
"type": "string"
},
"modifiedon": {
"type": "string"
},
"_msdyn_bookingsetupmetadataid_value": {
"type": "string"
},
"_msdyn_bookingsetupmetadataid_type": {
"type": "string"
},
"indusa_factoryrepname": {
"type": "string"
},
"starttime": {
"type": "string"
},
"_bookingstatus_value": {
"type": "string"
},
"_bookingstatus_type": {
"type": "string"
},
"versionnumber": {
"type": "integer"
},
"indusa_firstattempt": {
"type": "boolean"
},
"indusa_isfromcustomtool": {
"type": "boolean"
},
"indusa_previousdate": {
"type": "string"
},
"msdyn_estimatedtravelduration": {
"type": "integer"
},
"_msdyn_workorder_value": {
"type": "string"
},
"_msdyn_workorder_type": {
"type": "string"
},
"_transactioncurrencyid_value": {
"type": "string"
},
"_transactioncurrencyid_type": {
"type": "string"
},
"duration": {
"type": "integer"
},
"msdyn_preventtimestampcreation": {
"type": "boolean"
},
"indusa_updatefrompowerapp": {
"type": "boolean"
},
"indusa_zverifiedtestoptionset": {
"type": "boolean"
},
"_modifiedby_value": {
"type": "string"
},
"_modifiedby_type": {
"type": "string"
},
"_createdby_value": {
"type": "string"
},
"_createdby_type": {
"type": "string"
},
"indusa_isdeletedfromcustomassignmenttool": {
"type": "boolean"
},
"indusa_confirmed": {
"type": "boolean"
},
"_indusa_modifiedbycustom_value": {
"type": "string"
},
"_indusa_modifiedbycustom_type": {
"type": "string"
},
"_msdyn_resourcerequirement_value": {
"type": "string"
},
"_msdyn_resourcerequirement_type": {
"type": "string"
},
"statecode": {
"type": "integer"
},
"_statecode_label": {
"type": "string"
},
"indusa_isbookingcancelfromschedulebrd": {
"type": "boolean"
},
"_modifiedonbehalfby_value": {},
"_indusa_caseid_value": {},
"msdyn_internalflags": {},
"_msdyn_projectteamid_value": {},
"indusa_customeraddress": {},
"msdyn_slottext": {},
"_msdyn_timegroupdetailselected_value": {},
"indusa_leadpaintstatus": {},
"_indusa_leadpaintstatus_label": {
"type": "string"
},
"indusa_allsecondaryproducts": {},
"indusa_roofingmsrp_base": {},
"traversedpath": {},
"indusa_entrydoorappointmentstatus": {},
"_indusa_entrydoorappointmentstatus_label": {
"type": "string"
},
"msdyn_latitude": {},
"indusa_roofinglastpriceoffered_base": {},
"indusa_entrydoors": {},
"indusa_garagedoorsmsrp": {},
"indusa_sidinglastpriceoffered_base": {},
"indusa_entrydoormsrp_base": {},
"_indusa_clonedfrom_value": {},
"indusa_windowsmsrp": {},
"indusa_sidingpar": {},
"_indusa_followupresource_value": {},
"indusa_garagedoorspar_base": {},
"_indusa_lastbookinghistory_value": {},
"indusa_windowappointmentstatus": {},
"_indusa_windowappointmentstatus_label": {
"type": "string"
},
"indusa_secondarycontact": {},
"indusa_sidingquantity": {},
"indusa_entrydoorquantity": {},
"indusa_officesales": {},
"_createdonbehalfby_value": {},
"_indusa_salesorder_value": {},
"stageid": {},
"indusa_garagedoorslastpriceoffered_base": {},
"indusa_entrydoormsrp": {},
"msdyn_totalbreakduration": {},
"indusa_window": {},
"indusa_windowspar_base": {},
"indusa_roofing": {},
"indusa_entrydoorslastpriceoffered": {},
"indusa_roofingquantity": {},
"indusa_removebookingvalue": {},
"msdyn_signature": {},
"_msdyn_agreementbookingdate_value": {},
"utcconversiontimezonecode": {},
"msdyn_totalcost": {},
"msdyn_actualtravelduration": {},
"indusa_roofinglastpriceoffered": {},
"_indusa_financingrecord_value": {},
"indusa_sunroomsquantity": {},
"indusa_windowslastpriceoffered": {},
"msdyn_longitude": {},
"indusa_sunrooms": {},
"indusa_leadid": {},
"_msdyn_resourcegroup_value": {},
"indusa_sidingmsrp": {},
"indusa_windowsmsrp_base": {},
"indusa_garagedoorspar": {},
"indusa_sunroomslastpriceoffered": {},
"_msdyn_projectid_value": {},
"indusa_sunroomsmsrp": {},
"indusa_yearbuilt": {},
"indusa_windowspar": {},
"_header_value": {},
"msdyn_actualarrivaltime": {},
"indusa_description": {},
"indusa_garagedoorsmsrp_base": {},
"indusa_resultvalue": {},
"_indusa_resultvalue_label": {
"type": "string"
},
"indusa_sidingappointmentstatus": {},
"_indusa_sidingappointmentstatus_label": {
"type": "string"
},
"indusa_financeapplied": {},
"_indusa_financeapplied_label": {
"type": "string"
},
"msdyn_milestraveled": {},
"indusa_resultcomments": {},
"indusa_sunroomsmsrp_base": {},
"indusa_result": {},
"_indusa_result_label": {
"type": "string"
},
"msdyn_totalbillableduration": {},
"indusa_powerappsearchdata": {},
"indusa_resultoption": {},
"_indusa_resultoption_label": {
"type": "string"
},
"indusa_bookingstatuslabel": {},
"indusa_sidinglastpriceoffered": {},
"indusa_primaryproduct": {},
"_indusa_quoteid_value": {},
"indusa_sidingmsrp_base": {},
"indusa_entrydoorslastpriceoffered_base": {},
"indusa_roofingpar": {},
"msdyn_totaldurationinprogress": {},
"indusa_garagedoors": {},
"indusa_resourcetoguid": {},
"indusa_roofingappointmentstatus": {},
"_indusa_roofingappointmentstatus_label": {
"type": "string"
},
"indusa_resulttext": {},
"msdyn_totalcost_base": {},
"indusa_windowsquantity": {},
"indusa_entrydoorpar": {},
"indusa_entrydoorpar_base": {},
"msdyn_offlinetimestamp": {},
"indusa_sunroompar": {},
"indusa_sidingpar_base": {},
"indusa_financedoffered": {},
"_indusa_financedoffered_label": {
"type": "string"
},
"indusa_garagedoorsquantity": {},
"indusa_sunroompar_base": {},
"_indusa_actualresource_value": {},
"indusa_sunroomappointmentstatus": {},
"_indusa_sunroomappointmentstatus_label": {
"type": "string"
},
"indusa_garagedoorappointmentstatus": {},
"_indusa_garagedoorappointmentstatus_label": {
"type": "string"
},
"indusa_leadsource": {},
"_indusa_leadsource_label": {
"type": "string"
},
"indusa_sunroomslastpriceoffered_base": {},
"indusa_roofingpar_base": {},
"_indusa_planoffered_value": {},
"indusa_windowslastpriceoffered_base": {},
"_indusa_lead_value": {},
"indusa_garagedoorslastpriceoffered": {},
"indusa_financingrecordguid": {},
"_owningteam_value": {},
"indusa_siding": {},
"indusa_whenwillyoufollowup": {},
"processid": {},
"indusa_roofingmsrp": {},
"overriddencreatedon": {},
"indusa_bookingnotes": {},
"_msdyn_resourcecategoryid_value": {},
"_owninguser_value": {},
"_indusa_lead_type": {
"type": "string"
},
"_modifiedonbehalfby_type": {
"type": "string"
},
"_indusa_actualresource_type": {
"type": "string"
}
},
"required": [
"@@odata.etag",
"ItemInternalId",
"msdyn_allowoverlapping",
"indusa_verified",
"exchangerate",
"indusa_resourceemailid",
"endtime",
"bookingtype",
"_bookingtype_label",
"_resource_value",
"_resource_type",
"name",
"indusa_iscreatedupdatedflag",
"_owningbusinessunit_value",
"_owningbusinessunit_type",
"_indusa_createdbycustom_value",
"_indusa_createdbycustom_type",
"indusa_customer",
"importsequencenumber",
"_ownerid_value",
"_ownerid_type",
"indusa_nextdate",
"bookableresourcebookingid",
"_indusa_currentresidenthh_value",
"_indusa_currentresidenthh_type",
"msdyn_cascadecrewchanges",
"_indusa_championbookingtype_value",
"_indusa_championbookingtype_type",
"indusa_ismodified",
"indusa_willyoufollow",
"msdyn_bookingmethod",
"_msdyn_bookingmethod_label",
"timezoneruleversionnumber",
"statuscode",
"_statuscode_label",
"createdon",
"msdyn_traveltimerescheduling",
"msdyn_estimatedarrivaltime",
"modifiedon",
"_msdyn_bookingsetupmetadataid_value",
"_msdyn_bookingsetupmetadataid_type",
"indusa_factoryrepname",
"starttime",
"_bookingstatus_value",
"_bookingstatus_type",
"versionnumber",
"indusa_firstattempt",
"indusa_isfromcustomtool",
"indusa_previousdate",
"msdyn_estimatedtravelduration",
"_msdyn_workorder_value",
"_msdyn_workorder_type",
"_transactioncurrencyid_value",
"_transactioncurrencyid_type",
"duration",
"msdyn_preventtimestampcreation",
"indusa_updatefrompowerapp",
"indusa_zverifiedtestoptionset",
"_modifiedby_value",
"_modifiedby_type",
"_createdby_value",
"_createdby_type",
"indusa_isdeletedfromcustomassignmenttool",
"indusa_confirmed",
"_indusa_modifiedbycustom_value",
"_indusa_modifiedbycustom_type",
"_msdyn_resourcerequirement_value",
"_msdyn_resourcerequirement_type",
"statecode",
"_statecode_label",
"indusa_isbookingcancelfromschedulebrd",
"_modifiedonbehalfby_value",
"_indusa_caseid_value",
"msdyn_internalflags",
"_msdyn_projectteamid_value",
"indusa_customeraddress",
"msdyn_slottext",
"_msdyn_timegroupdetailselected_value",
"indusa_leadpaintstatus",
"_indusa_leadpaintstatus_label",
"indusa_allsecondaryproducts",
"indusa_roofingmsrp_base",
"traversedpath",
"indusa_entrydoorappointmentstatus",
"_indusa_entrydoorappointmentstatus_label",
"msdyn_latitude",
"indusa_roofinglastpriceoffered_base",
"indusa_entrydoors",
"indusa_garagedoorsmsrp",
"indusa_sidinglastpriceoffered_base",
"indusa_entrydoormsrp_base",
"_indusa_clonedfrom_value",
"indusa_windowsmsrp",
"indusa_sidingpar",
"_indusa_followupresource_value",
"indusa_garagedoorspar_base",
"_indusa_lastbookinghistory_value",
"indusa_windowappointmentstatus",
"_indusa_windowappointmentstatus_label",
"indusa_secondarycontact",
"indusa_sidingquantity",
"indusa_entrydoorquantity",
"indusa_officesales",
"_createdonbehalfby_value",
"_indusa_salesorder_value",
"stageid",
"indusa_garagedoorslastpriceoffered_base",
"indusa_entrydoormsrp",
"msdyn_totalbreakduration",
"indusa_window",
"indusa_windowspar_base",
"indusa_roofing",
"indusa_entrydoorslastpriceoffered",
"indusa_roofingquantity",
"indusa_removebookingvalue",
"msdyn_signature",
"_msdyn_agreementbookingdate_value",
"utcconversiontimezonecode",
"msdyn_totalcost",
"msdyn_actualtravelduration",
"indusa_roofinglastpriceoffered",
"_indusa_financingrecord_value",
"indusa_sunroomsquantity",
"indusa_windowslastpriceoffered",
"msdyn_longitude",
"indusa_sunrooms",
"indusa_leadid",
"_msdyn_resourcegroup_value",
"indusa_sidingmsrp",
"indusa_windowsmsrp_base",
"indusa_garagedoorspar",
"indusa_sunroomslastpriceoffered",
"_msdyn_projectid_value",
"indusa_sunroomsmsrp",
"indusa_yearbuilt",
"indusa_windowspar",
"_header_value",
"msdyn_actualarrivaltime",
"indusa_description",
"indusa_garagedoorsmsrp_base",
"indusa_resultvalue",
"_indusa_resultvalue_label",
"indusa_sidingappointmentstatus",
"_indusa_sidingappointmentstatus_label",
"indusa_financeapplied",
"_indusa_financeapplied_label",
"msdyn_milestraveled",
"indusa_resultcomments",
"indusa_sunroomsmsrp_base",
"indusa_result",
"_indusa_result_label",
"msdyn_totalbillableduration",
"indusa_powerappsearchdata",
"indusa_resultoption",
"_indusa_resultoption_label",
"indusa_bookingstatuslabel",
"indusa_sidinglastpriceoffered",
"indusa_primaryproduct",
"_indusa_quoteid_value",
"indusa_sidingmsrp_base",
"indusa_entrydoorslastpriceoffered_base",
"indusa_roofingpar",
"msdyn_totaldurationinprogress",
"indusa_garagedoors",
"indusa_resourcetoguid",
"indusa_roofingappointmentstatus",
"_indusa_roofingappointmentstatus_label",
"indusa_resulttext",
"msdyn_totalcost_base",
"indusa_windowsquantity",
"indusa_entrydoorpar",
"indusa_entrydoorpar_base",
"msdyn_offlinetimestamp",
"indusa_sunroompar",
"indusa_sidingpar_base",
"indusa_financedoffered",
"_indusa_financedoffered_label",
"indusa_garagedoorsquantity",
"indusa_sunroompar_base",
"_indusa_actualresource_value",
"indusa_sunroomappointmentstatus",
"_indusa_sunroomappointmentstatus_label",
"indusa_garagedoorappointmentstatus",
"_indusa_garagedoorappointmentstatus_label",
"indusa_leadsource",
"_indusa_leadsource_label",
"indusa_sunroomslastpriceoffered_base",
"indusa_roofingpar_base",
"_indusa_planoffered_value",
"indusa_windowslastpriceoffered_base",
"_indusa_lead_value",
"indusa_garagedoorslastpriceoffered",
"indusa_financingrecordguid",
"indusa_siding",
"indusa_whenwillyoufollowup",
"processid",
"indusa_roofingmsrp",
"overriddencreatedon",
"indusa_bookingnotes",
"_msdyn_resourcecategoryid_value"
]
}
}
}
}In filter array body output:
[
{
"@odata.etag": "",
"ItemInternalId": "b4c6b230-39a9-e911-a95d-000d3a34e00b",
"msdyn_longitude": 0,
"msdyn_latitude": 0,
"indusa_roofing": false,
"msdyn_allowoverlapping": false,
"indusa_verified": false,
"exchangerate": 1,
"_indusa_lead_value": "aa5c82ac-9aa8-e911-a95b-000d3a34e00b",
"_indusa_lead_type": "leads",
"bookingtype": 1,
"_bookingtype_label": "Solid",
"_resource_value": "021cff86-1a10-e911-a94f-000d3a34e00b",
"_resource_type": "bookableresources",
"indusa_financeapplied": null,
"_indusa_financeapplied_label": "",
"name": "Slaughter-1046090",
"indusa_iscreatedupdatedflag": false,
"_owningbusinessunit_value": "238db586-796d-e811-8117-5065f38b01d1",
"_owningbusinessunit_type": "businessunits",
"_indusa_createdbycustom_value": "394e4096-429d-e611-8104-3863bb2ba808",
"_indusa_createdbycustom_type": "systemusers",
"indusa_customer": "Dona D. Slaughter",
"indusa_primaryproduct": "WINDOWS",
"importsequencenumber": 0,
"_ownerid_value": "e7e5f09f-7c6d-e811-8117-5065f38b01d1",
"_ownerid_type": "teams",
"indusa_nextdate": "2019-08-01T17:00:00Z",
"bookableresourcebookingid": "b4c6b230-39a9-e911-a95d-000d3a34e00b",
"_indusa_currentresidenthh_value": "a142859a-9aa8-e911-a95b-000d3a34e00b",
"_indusa_currentresidenthh_type": "contacts",
"msdyn_cascadecrewchanges": false,
"_indusa_championbookingtype_value": "c9e0d8a7-5948-e611-80e6-3863bb36cda8",
"_indusa_championbookingtype_type": "msdyn_workordertypes",
"endtime": "2019-07-24T20:00:00Z",
"indusa_sunrooms": false,
"indusa_ismodified": false,
"indusa_resourceemailid": "Indusa.PVyas@championwindow.com",
"indusa_willyoufollow": false,
"msdyn_bookingmethod": 690970001,
"_msdyn_bookingmethod_label": "Schedule Board",
"indusa_updatefrompowerapp": false,
"indusa_entrydoors": false,
"timezoneruleversionnumber": 0,
"indusa_garagedoors": false,
"statuscode": 1,
"_statuscode_label": "Active",
"createdon": "2019-07-18T08:51:18Z",
"msdyn_traveltimerescheduling": false,
"msdyn_estimatedarrivaltime": "2019-07-24T17:00:00Z",
"indusa_window": true,
"indusa_result": null,
"_indusa_result_label": "",
"_msdyn_bookingsetupmetadataid_value": "d59df12a-aedb-4f82-b5b8-9a6eba4f1712",
"_msdyn_bookingsetupmetadataid_type": "msdyn_bookingsetupmetadatas",
"indusa_factoryrepname": "Indusa Payal Vyas",
"starttime": "2019-07-24T17:00:00Z",
"_bookingstatus_value": "e1b1a65d-f978-e711-815a-e0071b711c31",
"_bookingstatus_type": "bookingstatuses",
"versionnumber": 26408163,
"indusa_financedoffered": null,
"_indusa_financedoffered_label": "",
"indusa_siding": false,
"modifiedon": "2019-07-18T11:23:32Z",
"indusa_isfromcustomtool": false,
"indusa_previousdate": "2019-07-16T17:00:00Z",
"indusa_customeraddress": "1116 Derek Drive\r\nCable, OH 43009\r\nUSA",
"_msdyn_workorder_value": "4a0d8f0d-9ba8-e911-a95b-000d3a34e00b",
"_msdyn_workorder_type": "msdyn_workorders",
"_transactioncurrencyid_value": "a2c1599c-4a48-e611-80e5-3863bb353c20",
"_transactioncurrencyid_type": "transactioncurrencies",
"duration": 180,
"msdyn_preventtimestampcreation": false,
"indusa_zverifiedtestoptionset": false,
"_modifiedby_value": "3e1d730b-d86a-e611-80ed-3863bb353c20",
"_modifiedby_type": "systemusers",
"_createdby_value": "394e4096-429d-e611-8104-3863bb2ba808",
"_createdby_type": "systemusers",
"indusa_allsecondaryproducts": null,
"indusa_isdeletedfromcustomassignmenttool": false,
"indusa_confirmed": false,
"msdyn_estimatedtravelduration": 0,
"_indusa_modifiedbycustom_value": "394e4096-429d-e611-8104-3863bb2ba808",
"_indusa_modifiedbycustom_type": "systemusers",
"_msdyn_resourcerequirement_value": "5d0d8f0d-9ba8-e911-a95b-000d3a34e00b",
"_msdyn_resourcerequirement_type": "msdyn_resourcerequirements",
"indusa_leadsource": 61,
"_indusa_leadsource_label": "Online",
"indusa_firstattempt": false,
"statecode": 0,
"_statecode_label": "Active",
"indusa_leadid": "1046090",
"indusa_isbookingcancelfromschedulebrd": false,
"_modifiedonbehalfby_value": null,
"_indusa_caseid_value": null,
"msdyn_internalflags": null,
"_msdyn_projectteamid_value": null,
"msdyn_slottext": null,
"_msdyn_timegroupdetailselected_value": null,
"indusa_leadpaintstatus": null,
"_indusa_leadpaintstatus_label": "",
"indusa_roofingmsrp_base": null,
"traversedpath": null,
"indusa_entrydoorappointmentstatus": null,
"_indusa_entrydoorappointmentstatus_label": "",
"indusa_roofinglastpriceoffered_base": null,
"indusa_garagedoorsmsrp": null,
"indusa_sidinglastpriceoffered_base": null,
"indusa_entrydoormsrp_base": null,
"_indusa_clonedfrom_value": null,
"indusa_windowsmsrp": null,
"indusa_sidingpar": null,
"_indusa_followupresource_value": null,
"indusa_garagedoorspar_base": null,
"_indusa_lastbookinghistory_value": null,
"indusa_windowappointmentstatus": null,
"_indusa_windowappointmentstatus_label": "",
"indusa_secondarycontact": null,
"indusa_sidingquantity": null,
"indusa_entrydoorquantity": null,
"indusa_officesales": null,
"_createdonbehalfby_value": null,
"_indusa_salesorder_value": null,
"stageid": null,
"indusa_garagedoorslastpriceoffered_base": null,
"indusa_entrydoormsrp": null,
"msdyn_totalbreakduration": null,
"indusa_windowspar_base": null,
"indusa_entrydoorslastpriceoffered": null,
"indusa_roofingquantity": null,
"indusa_removebookingvalue": null,
"msdyn_signature": null,
"_msdyn_agreementbookingdate_value": null,
"utcconversiontimezonecode": null,
"msdyn_totalcost": null,
"msdyn_actualtravelduration": null,
"indusa_roofinglastpriceoffered": null,
"_indusa_financingrecord_value": null,
"indusa_sunroomsquantity": null,
"indusa_windowslastpriceoffered": null,
"_msdyn_resourcegroup_value": null,
"indusa_sidingmsrp": null,
"indusa_windowsmsrp_base": null,
"indusa_garagedoorspar": null,
"indusa_sunroomslastpriceoffered": null,
"_msdyn_projectid_value": null,
"indusa_sunroomsmsrp": null,
"indusa_yearbuilt": null,
"indusa_windowspar": null,
"_header_value": null,
"msdyn_actualarrivaltime": null,
"indusa_description": null,
"indusa_garagedoorsmsrp_base": null,
"indusa_resultvalue": null,
"_indusa_resultvalue_label": "",
"indusa_sidingappointmentstatus": null,
"_indusa_sidingappointmentstatus_label": "",
"msdyn_milestraveled": null,
"indusa_resultcomments": null,
"indusa_sunroomsmsrp_base": null,
"msdyn_totalbillableduration": null,
"indusa_powerappsearchdata": "Dona D. Slaughter",
"indusa_resultoption": null,
"_indusa_resultoption_label": "",
"indusa_bookingstatuslabel": "Assigned",
"indusa_sidinglastpriceoffered": null,
"_indusa_quoteid_value": null,
"_owninguser_value": null,
"indusa_sidingmsrp_base": null,
"indusa_entrydoorslastpriceoffered_base": null,
"indusa_roofingpar": null,
"msdyn_totaldurationinprogress": null,
"indusa_resourcetoguid": null,
"indusa_roofingappointmentstatus": null,
"_indusa_roofingappointmentstatus_label": "",
"indusa_resulttext": null,
"msdyn_totalcost_base": null,
"indusa_windowsquantity": null,
"indusa_entrydoorpar": null,
"indusa_entrydoorpar_base": null,
"msdyn_offlinetimestamp": null,
"indusa_sunroompar": null,
"indusa_sidingpar_base": null,
"indusa_garagedoorsquantity": null,
"indusa_sunroompar_base": null,
"_indusa_actualresource_value": null,
"indusa_sunroomappointmentstatus": null,
"_indusa_sunroomappointmentstatus_label": "",
"indusa_garagedoorappointmentstatus": null,
"_indusa_garagedoorappointmentstatus_label": "",
"indusa_sunroomslastpriceoffered_base": null,
"indusa_roofingpar_base": null,
"_indusa_planoffered_value": null,
"indusa_windowslastpriceoffered_base": null,
"indusa_garagedoorslastpriceoffered": null,
"indusa_financingrecordguid": null,
"indusa_whenwillyoufollowup": null,
"processid": null,
"indusa_roofingmsrp": null,
"overriddencreatedon": null,
"indusa_bookingnotes": null,
"_msdyn_resourcecategoryid_value": null
}
]can you let me know where I am doing mistake ?
Thanks in advance.
Thank you,
Milansinh Raj
I have removed fields which have not been assigned with a proper type from the properties part.
And also tried to create new flow from PowerApps, this time I have created for contact.
When I test flow in Microsoft flow its shows as below result:
{
"@odata.etag": "",
"ItemInternalId": "834c927f-f101-e911-a94c-000d3a34e00b",
"customertypecode": 1,
"_customertypecode_label": "Default Value",
"indusa_withincitylimit": "Yes",
"address1_latitude": 39.951577533673294,
"merged": false,
"_modifiedby_value": "394e4096-429d-e611-8104-3863bb2ba808",
"_modifiedby_type": "systemusers",
"indusa_sidingcs": null,
"_indusa_sidingcs_label": "",
"territorycode": 1,
"_territorycode_label": "Default Value",
"haschildrencode": 1,
"_haschildrencode_label": "Default Value",
"indusa_nextapptdateandtime": null,
"exchangerate": 1,
"preferredappointmenttimecode": 1,
"_preferredappointmenttimecode_label": "Morning",
"adx_profilealert": false,
"indusa_possibleduplicates": false,
"adx_partner_accountcreated": false,
"indusa_garagedoorscs": null,
"_indusa_garagedoorscs_label": "",
"adx_geo_apac": false,
"isbackofficecustomer": false,
"_owningbusinessunit_value": "238db586-796d-e811-8117-5065f38b01d1",
"_owningbusinessunit_type": "businessunits",
"indusa_isphonemobile": false,
"adx_geo_southamerica": false,
"indusa_originalowner": "Dayton",
"adx_partner_applicationsubmitted": false,
"address1_composite": "3728 Olive Street\r\nCable, OH 43009\r\nUSA",
"address1_longitude": -83.09058403501514,
"donotpostalmail": false,
"marketingonly": false,
"adx_geo_emea": false,
"donotphone": false,
"indusa_windowscs": null,
"_indusa_windowscs_label": "",
"preferredcontactmethodcode": 1,
"_preferredcontactmethodcode_label": "Any",
"adx_identity_locallogindisabled": false,
"educationcode": 1,
"_educationcode_label": "Default Value",
"_ownerid_value": "e7e5f09f-7c6d-e811-8117-5065f38b01d1",
"_ownerid_type": "teams",
"adx_profileisanonymous": false,
"adx_identity_logonenabled": false,
"customersizecode": 1,
"_customersizecode_label": "Default Value",
"indusa_roofingcs": null,
"_indusa_roofingcs_label": "",
"adx_identity_lockoutenabled": false,
"indusa_isitbillable": false,
"yomifullname": "Michael D. Hill",
"address2_addresstypecode": 1,
"_address2_addresstypecode_label": "Default Value",
"adx_geo_australia": false,
"donotemail": false,
"adx_identity_mobilephoneconfirmed": false,
"indusa_customergroup": 1,
"_indusa_customergroup_label": "HomeOwner",
"fullname": "Michael D. Hill",
"timezoneruleversionnumber": null,
"msdyn_gdproptout": false,
"statuscode": 1,
"_statuscode_label": "Active",
"createdon": "2018-12-17T11:47:16Z",
"address1_stateorprovince": "OH",
"lastname": "Hill",
"donotsendmm": false,
"donotfax": false,
"leadsourcecode": 1,
"_leadsourcecode_label": "Default Value",
"firstname": "Michael D.",
"address1_country": "USA",
"versionnumber": 23355876,
"address1_line1": "3728 Olive Street",
"modifiedon": "2019-05-17T13:31:48Z",
"creditonhold": false,
"indusa_unsubscribe": false,
"adx_identity_emailaddress1confirmed": false,
"msdyn_isminor": false,
"adx_interestedinpartnerenrollment": true,
"_transactioncurrencyid_value": "a2c1599c-4a48-e611-80e5-3863bb353c20",
"_transactioncurrencyid_type": "transactioncurrencies",
"msdyn_isminorwithparentalconsent": false,
"donotbulkemail": false,
"indusa_doorscs": null,
"_indusa_doorscs_label": "",
"indusa_bookingtype": null,
"adx_identity_twofactorenabled": false,
"followemail": true,
"shippingmethodcode": 1,
"_shippingmethodcode_label": "Default Value",
"indusa_iaminterestedinreceivingpromotions": false,
"_createdby_value": "394e4096-429d-e611-8104-3863bb2ba808",
"_createdby_type": "systemusers",
"indusa_isresidence": true,
"address1_city": "Cable",
"donotbulkpostalmail": false,
"indusa_axcontactid": "5300000689",
"adx_geo_northamerica": false,
"contactid": "834c927f-f101-e911-a94c-000d3a34e00b",
"msdyn_disablewebtracking": false,
"indusa_ispobox": false,
"participatesinworkflow": false,
"statecode": 0,
"_statecode_label": "Active",
"address1_postalcode": "43009",
"indusa_leadreason": null,
"emailaddress2": null,
"_indusa_storeprimaryrecipient_value": null,
"address3_utcoffset": null,
"cdi_social": null,
"_preferredsystemuserid_value": null,
"cdi_rowkey": null,
"adx_partneryearsofrelevantexperience": null,
"aging90": null,
"msdyn_portaltermsagreementdate": null,
"address2_utcoffset": null,
"indusa_yardsign4": null,
"_preferredequipmentid_value": null,
"indusa_resultvalue": null,
"indusa_yearbuilt": null,
"managerphone": null,
"cdi_allowtextmessages": null,
"accountrolecode": null,
"_accountrolecode_label": "",
"indusa_axcustomeroutstandingbalance": null,
"childrensnames": null,
"address1_addresstypecode": null,
"_address1_addresstypecode_label": "",
"utcconversiontimezonecode": null,
"annualincome_base": null,
"adx_partnernumberofemployees": null,
"indusa_gamedium": null,
"adx_partner_technologies": null,
"address3_telephone1": null,
"onholdtime": null,
"entityimageid": null,
"address2_postalcode": null,
"annualincome": null,
"aging60": null,
"address3_shippingmethodcode": null,
"adx_identity_passwordhash": null,
"indusa_noapptreason": null,
"governmentid": null,
"_parentcontactid_value": null,
"address2_name": null,
"address1_postofficebox": null,
"adx_identity_lockoutenddate": null,
"callback": null,
"adx_createdbyipaddress": null,
"address2_line2": null,
"traversedpath": null,
"indusa_resultoption": null,
"address1_fax": null,
"indusa_gasource": null,
"address1_telephone3": null,
"indusa_sunroomscs": null,
"_indusa_sunroomscs_label": "",
"_owninguser_value": null,
"gendercode": null,
"_gendercode_label": "",
"anniversary": null,
"address2_composite": null,
"cdi_facebook": null,
"birthdate": null,
"adx_partner_anniversarydate": null,
"adx_modifiedbyipaddress": null,
"salutation": null,
"home2": null,
"telephone3": null,
"address1_line2": null,
"aging60_base": null,
"_indusa_testlead_value": null,
"cdi_age": null,
"pager": null,
"adx_partner_applicationdate": null,
"_adx_preferredlanguageid_value": null,
"address2_primarycontactname": null,
"suffix": null,
"adx_organizationname": null,
"fax": null,
"adx_partnercontactrole": null,
"_adx_partnercontactrole_label": "",
"address2_latitude": null,
"address1_shippingmethodcode": null,
"_defaultpricelevelid_value": null,
"msdyn_orgchangestatus": null,
"_msdyn_orgchangestatus_label": "",
"cdi_identifiedon": null,
"yomilastname": null,
"processid": null,
"address2_county": null,
"adx_partnerkeyreferences": null,
"address3_latitude": null,
"address3_telephone2": null,
"paymenttermscode": null,
"_paymenttermscode_label": "",
"address1_primarycontactname": null,
"_indusa_acsteamrecipient_value": null,
"address3_postofficebox": null,
"teamsfollowed": null,
"address3_line2": null,
"address3_line1": null,
"indusa_axparentcustomerid": null,
"externaluseridentifier": null,
"_adx_createdbyportalcontactid_value": null,
"_preferredserviceid_value": null,
"importsequencenumber": null,
"adx_profilealertdate": null,
"adx_competencies": null,
"_indusa_spousepartnername_value": null,
"indusa_yardsign3": null,
"address1_telephone2": null,
"_originatingleadid_value": null,
"address3_stateorprovince": null,
"indusa_axcustomeroutstandingbalance_base": null,
"cdi_linkedin": null,
"_parentcustomerid_value": null,
"address1_county": null,
"address3_composite": null,
"_slaid_value": null,
"aging90_base": null,
"spousesname": null,
"adx_identity_accessfailedcount": null,
"_slainvokedid_value": null,
"adx_publicprofilecopy": null,
"yomifirstname": null,
"address3_addresstypecode": null,
"_address3_addresstypecode_label": "",
"address2_line3": null,
"address2_fax": null,
"cdi_longitude": null,
"address1_utcoffset": null,
"_createdonbehalfby_value": null,
"indusa_lpc": null,
"adx_modifiedbyusername": null,
"managername": null,
"assistantname": null,
"numberofchildren": null,
"cdi_totalscore": null,
"address2_postofficebox": null,
"adx_profilemodifiedon": null,
"stageid": null,
"websiteurl": null,
"adx_createdbyusername": null,
"yomimiddlename": null,
"creditlimit_base": null,
"_createdbyexternalparty_value": null,
"entityimage": null,
"indusa_yardsign2": null,
"employeeid": null,
"_msa_managingpartnerid_value": null,
"telephone2": null,
"company": null,
"address3_freighttermscode": null,
"jobtitle": null,
"indusa_accesscontact": null,
"mobilephone": null,
"entityimage_url": null,
"indusa_noapptnotes": null,
"description": null,
"address2_telephone2": null,
"cdi_ip": null,
"indusa_phonetic": null,
"cdi_visitorkey": null,
"assistantphone": null,
"indusa_gacontent": null,
"indusa_yardsign1": null,
"ftpsiteurl": null,
"adx_partner_applicationstatus": null,
"_adx_partner_applicationstatus_label": "",
"address3_fax": null,
"creditlimit": null,
"address3_line3": null,
"overriddencreatedon": null,
"champion_accesscustomerid": null,
"adx_profilelastactivity": null,
"aging30": null,
"_modifiedonbehalfby_value": null,
"address3_longitude": null,
"address1_line3": null,
"address1_telephone1": null,
"_accountid_value": null,
"telephone1": null,
"preferredappointmentdaycode": null,
"_preferredappointmentdaycode_label": "",
"cdi_latitude": null,
"adx_timezone": null,
"address2_telephone3": null,
"indusa_updaterecordnames": null,
"_modifiedbyexternalparty_value": null,
"department": null,
"address1_name": null,
"address3_primarycontactname": null,
"_masterid_value": null,
"address3_city": null,
"cdi_grade": null,
"address3_county": null,
"emailaddress1": null,
"business2": null,
"aging30_base": null,
"emailaddress3": null,
"adx_profilealertinstructions": null,
"address3_upszone": null,
"adx_identity_lastsuccessfullogin": null,
"address2_line1": null,
"adx_identity_username": null,
"address3_telephone3": null,
"address2_upszone": null,
"lastusedincampaign": null,
"address1_upszone": null,
"familystatuscode": null,
"_familystatuscode_label": "",
"entityimage_timestamp": null,
"indusa_contactroles": null,
"_indusa_contactroles_label": "",
"cdi_partitionkey": null,
"cdi_score": null,
"address3_country": null,
"address3_postalcode": null,
"address3_name": null,
"indusa_noapptreasoncode": null,
"indusa_callback": null,
"adx_partner_targetmarket": null,
"adx_identity_securitystamp": null,
"subscriptionid": null,
"lastonholdtime": null,
"nickname": null,
"indusa_gacampaign": null,
"address2_country": null,
"timespentbymeonemailandmeetings": null,
"address2_stateorprovince": null,
"cdi_image": null,
"address1_freighttermscode": null,
"_address1_freighttermscode_label": "",
"indusa_leadpaintstatus": null,
"middlename": null,
"address2_longitude": null,
"indusa_spouseid": null,
"indusa_gakeywords": null,
"address2_city": null,
"cdi_twitter": null,
"address2_telephone1": null
}I have written on button - ClearCollect(dataContact,PowerAppsDemoFlow.Run())
But when I check on PowerApps collection:
Not able to get where I am doing wrong step.
Helpful resources
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Register for a Free Workshop
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
New Release Planning Portal (Preview)
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.
