Latest Contributions by DominicRobergeIADOT

‎01-25-2023

Thank you all for the information and quick response. I will try the dictionary approach and let you know how it goes. just a little bit of background on that project, I am running the Near geoprocessing on my Route and Mile Markers (and the RouteID is updated with the OBJECTID of the route, that's why I have to go back and update that RouteID with the RouteName... same with my Mile Markers) Then I do two intersects (structures with Parcels and Structures with Counties)... that's why I have to go back and update the structure fields I need from the parcels and counties data. Thanks!

‎01-24-2023

Hello, I have to update a feature class (16K records) based on four other feature classes. I am using the following code, which is working, but quite slow (about 35 min to complete). So, I was wondering if you guys could suggest some improvement to speed this up. Thanks! fieldsUpdate = ['OBJECTID','dr_Milepost','DR_distance_MP','Dr_Route','DR_DistanceFromRoute','DR_LANDOWNER_NAME','DR_PARCEL_NUMBER','DR_CountyName','DR_StateName'] fieldsM = ['OBJECTID', 'mile_post'] fieldsRoute = ['OBJECTID', 'id'] fieldsParcels = ['FID_Structures_NAD83_Update', 'LANDOWNER_NAME_1', 'PARCEL_NUMBER_1'] fieldsCounty = ['FID_Structures_NAD83_Update', 'CountyName_1', 'stateAbbr'] with arcpy.da.UpdateCursor(flStructure, fieldsUpdate) as cursorU: for rowU in cursorU: #Section to update the MilePost strMatch = "OBJECTID =" + str(rowU[1]) #print(strMatch) print("Mile post") with arcpy.da.SearchCursor(flMilePost, fieldsM,where_clause=strMatch) as cursorM: for rowM in cursorM: print(u'{0}'.format(rowM[1])) rowU[1] = rowM[1] rowU[2] = rowU[2] * 3.28084 # Section to update the Route print("Route") strMatchRoute = "OBJECTID =" + str(rowU[3]) with arcpy.da.SearchCursor(flRouteLYR, fieldsRoute,where_clause=strMatchRoute) as cursorR: for rowR in cursorR: #print(u'{0}'.format(rowR[0])) rowU[3] = rowR[1] rowU[4] = rowU[4] * 3.28084 ## Update using the intersect Parcels data print("Parcels") strMatchP = "FID_Structures_NAD83_Update ="+str(rowU[0]) with arcpy.da.SearchCursor(flParcels+"int", fieldsParcels,where_clause=strMatchP) as cursorP: for rowP in cursorP: rowU[5] = rowP[1] rowU[6] = rowP[2] ## Update using the intersect County data print("County") strMatchC = "FID_Structures_NAD83_Update =" + str(rowU[0]) with arcpy.da.SearchCursor(flCounty+"int", fieldsCounty,where_clause=strMatchC) as cursorC: for rowC in cursorC: rowU[7] = rowC[1] if rowC[2] == 'SD': rowU[8] = 'South Dakota' elif rowC[2]== 'ND': rowU[8] = 'North Dakota' elif rowC[2]== 'NE': rowU[8] = 'Nebraska' elif rowC[2]== 'MN': rowU[8] = 'Minnesota' elif rowC[2]== 'IA': rowU[8] = 'Iowa' else: rowU[8] = '' cursorU.updateRow(rowU)

‎01-12-2023

That is a nice tool, thanks for sharing. Unfortunately for me, seems like the webhook is triggered between 2 and 4 minutes (did 5 tests) which are consistent with I was getting within Power Automate. I will contact Support tomorrow. Thank you and I will update the post when I get more info. D

‎01-12-2023

I have no Fix Connections next to it, and both of my flows are using the same connection

‎01-12-2023

Hello I have to Power Automate flows that are very similar (one is based on a polygon HFL and the other one is a point HFL). Both layers have a refresh interval set to 0.5 MIN. Both layers have a web hook that has been created while building the flows using he ArcGIS Connector, and the frequency is set at 30 sec So my issue is: When I update a polygon record, the flow is triggered immediately (boom! fast). BUT when I update a point record, it takes 2 minutes for the flow to trigger What am I missing? Thank you!

‎01-11-2023

Well that's what I was thinking at first, but the time run is the same, no additional minutes. Then a friend of mine observed the same behavior on his AGOL starting January 3rd. Like me, he has scheduled Notebooks that have been setup since last November, nothing has changed since then. and his credit usage has ramped up as well. So, it has to be something else...

‎01-11-2023

Hello I have a few Notebooks (4) that are scheduled to run using the Task functionality (some every 15 min, some once a day). They have been setup in 2022 around August. Today I was looking at the Credits Report in AGOL and noticed that my credit usage for Notebooks have increased a lot since January 3rd 2023. Did ESRI changed their Notebook usage policies?

‎12-23-2022

I am experiencing the same issue on IOS 22.4.2 (build954) this functionality used to be working just fine and same as @RichSiko our field crews are relying on those URLs to pull asbuilt, service cards, etc.) it will works if you only have ONE media ... if you have multiple ... not working. I could create Arcade expressions but I would rather have the original functionality back PLEASE ESRI get this fix ASAP

‎12-22-2022

Hello I have a flow in Power Automate that pull data from a Dataverse table, and update a hosted feature layer on AGOL. Everything seems to be working fine EXCEPT for my Date fields. below is what is the payload form Dataverse { "@odata.editLink": "cr3c3_coa_projectses(a85d55b7-1f82-ed11-81ac-000d3a37d89e)", "cr3c3_coaprjstartdate@OData.Community.Display.V1.FormattedValue": "12/22/2022 6:00 AM", "cr3c3_coaprjstartdate@odata.type": "#DateTimeOffset", "cr3c3_coaprjstartdate": "2022-12-22T06:00:00Z", "_cr3c3_coaemployee_value@OData.Community.Display.V1.FormattedValue": "Dominic Roberge", "_cr3c3_coaemployee_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "cr3c3_coaEmployee", "_cr3c3_coaemployee_value@Microsoft.Dynamics.CRM.lookuplogicalname": "cr3c3_coa_stafflist", "_cr3c3_coaemployee_value@odata.type": "#Guid", "_cr3c3_coaemployee_value": "b302e0c1-2082-ed11-81ac-000d3a37dbf1", "cr3c3_coa_projectsid@odata.type": "#Guid", "cr3c3_coa_projectsid": "a85d55b7-1f82-ed11-81ac-000d3a37d89e", "statecode@OData.Community.Display.V1.FormattedValue": "Active", "statecode": 0, "statuscode@OData.Community.Display.V1.FormattedValue": "Active", "statuscode": 1, "_createdby_value@OData.Community.Display.V1.FormattedValue": "Dominic Roberge", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_value@odata.type": "#Guid", "_createdby_value": "14855649-5267-ed11-9561-000d3a37d89e", "cr3c3_coaprjname": "test revised no staff", "timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue": "4", "timezoneruleversionnumber": 4, "createdon@OData.Community.Display.V1.FormattedValue": "12/22/2022 5:40 PM", "createdon@odata.type": "#DateTimeOffset", "createdon": "2022-12-22T17:40:26Z", "cr3c3_prjuid": "7", } the 4th line has the data I am looking for to update my date field in AGOL. below is the error I am getting I have tried adding aFormatDateExpression (FormatDateTime(outputs('Get_a_row_by_ID')?['body/cr3c3_coaprjstartdate'],'MM-dd-yyyy')) but still no success. Any help would be much appreciated. Thanks!

‎12-13-2022

hello everyone sorry it took so long, I had open a ticket with ESRI Support regarding this issue and they finally created a BUG as they were able to replicate the issue: Bug Number: BUG-000154427 Synopsis: The Arcade expression configured in a form within a web map does not get honored in Map Viewer Any ideas how I could generate a unique ID automatically? Thanks!

‎11-24-2022

Thanks for the info. However when the expressio is enabled, I can't click the Create Feature button. when I test the expression it seems to be working if I disable the expresssion, then I can Create feature What am I missing? I also tested the process on a different HFL and different web map and same result.

‎11-23-2022

Hello I started playing with the ArcGIS connector as well and kept getting the same error as listed in the original message. I was using a Hosted Feature Layer with a relationship class (was published from a FGDB). Then I tested the same workflow with a HFL published from FGDB but no relationship and it worked. Could it be the problem?

‎11-23-2022

Hi Johannes thanks for helping me on this. I modified my expression accordingly and when I tried it in the web map.... nothing.... Then I decided to try it in the Field Maps app and it was working just fine (new record and updating existing record). I then tried to create and Experience Builder app to see how it would behave... same as web map, Empty FUID field. Any idea why it's not working properly in the web map? For this project, my users will enter/modify data either through a web map or experience builder app. Thanks!

‎11-22-2022

Hello I have the following Arcade code to create a new Unique ID on a feature layer (hosted on ArcGIS Server). It's working fine for a NEW record, but if I try to select an existing record, it will update the UID field with the next available number. How can I avoid to overwrite an existing value? Thanks for any help you could provide. D var fs=FeatureSetByName($datastore,'dr_testPts',['FUID'],false); var cCurrentFUID = $feature.FUID var fFilter = Filter(fs, 'FUID IS NOT NULL'); var fMax = 0 var tMax = 0 for (var k in fFilter){ fMax = Max(Right(k.FUID, Count(k.FUID)-3)) tMax = When(fMax>tMax,fMax, tMax) } tMax +=1 var vNewFUID = "EOC" + text(tMax, "00000") if (IsEmpty(cCurrentFUID)){ return vNewFUID } else { return cCurrentFUID }

‎11-09-2022

Hello Everyone Any updates on this BUG? I get the same error message but not on all web maps I am trying to load into Teams....

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by DominicRobergeIADOT

Re: Need help improving an UpdateCursor script

Need help improving an UpdateCursor script

Re: Record Updated in a Feature Layer take a long time to trigger flow

Re: Record Updated in a Feature Layer take a long time to trigger flow

Record Updated in a Feature Layer take a long time to trigger flow

Re: Notebook Credit usage increased in 2023

Notebook Credit usage increased in 2023

Re: URL link within field maps popup not working.

updating Date Field not working

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Re: Fetch Updates Error - Cannot read property 'headers' of undefined

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Arcade Generate new Unique ID for new record but not updating existing UID

Re: Don't have permission to view this item - Admin user and dashboard shared publicly

List widget Arcade expression to return message if...

Re: Record Updated in a Feature Layer take a long ...

AGOL Metadata dropdown list Values

Automating layout extent fail on one map

The selected layer does not support the truncate o...

Experience Builder Custom Widgets