Latest Contributions by ModernElectric

‎11-13-2024

Ended up contacting ESRI Tech Support and issued a trouble ticket for review.

‎11-13-2024

I understand ESRI did an AGOL update last night. This morning, one of our Superintendents was saying they cannot update the Status of the Assignments from the Workforce Hosted Feature Layer within an AGOL Web Map, even though they have editing powers. I thought this was a specific domain native to the Feature Layer that is created when a new Workforce project is created, and we have (as operators/admins) not control over. Any thoughts how we resolve this? @JeffShaner

‎11-08-2024

@RobertAnderson3 @IsmaelChivite @ZacharySutherby @JenniferAcunto There must be something I am missing. Using Power Automate, I keep getting an error message while using the ArcGIS Connector (orange) saying I need a Premium License. However, according to my knowledge, the ArcGIS for Microsoft 365 accepts a Creator ESRI license type. Is there a setting within Power Automate I need to update, even though I used my ESRI login credentials.

‎11-07-2024

@RobertAnderson3 Thank you for the information. Appears I need to #1 talk with my IT Officer about our Power Automate License(s) before I can continue development. I see there is more that I can use. Thank You for the feedback

‎11-05-2024

@RobertAnderson3 Thank you for the response. Can you clarify and point me in the right direction on what you are explaining? What I need to do is when the attributes are updated, lets say via ArcGIS Pro/Python script, to a Survey123 form, Power Automate is initiated to create a report. I have the flow configured, its the webhook and updating an existing survey/form from ArcGIS Pro that is the missing piece.

‎10-24-2024

UPDATE: @IsmaelChivite @ZacharySutherby @JenniferAcunto I have a Power Automate flow created that a PDF report is created (Action) when a form is submitted (Trigger). Works fine. Also, as part of the webhook, if the data is edited/updated from the Survey123 app or website, the Power Automate Flow will execute and produce another PDF report. HOWEVER: I have had to build a sub-process that exports the data from the AGOL portal to my local drive, run some data modifications and uploads the data from ArcGIS Pro back to the AGOL portal by using the Append tool. My thought was update/append/webhook Existing record edited would all mean the same time. Apparently not. If I run a geoprocessing tool from ArcGIS Pro and/or Python script, how can I set the webhook or Power Automate Trigger to execute the flow???? Any advice

‎10-24-2024

I have a DTSX package created in Visual Studio and wondering if there is a way to execute the package thru a Python script? It basically takes an Excel spreadsheet import, runs a derived Column tool and exports the results to a new Excel spreadsheet. Thank You

‎10-21-2024

@Robert_LeClair @DanPatterson Thank you for the information. I've tried the script you sent, and also found another script: with arcpy.da.SearchCursor(feature_class, [date_field]) as cursor: max_date = None for row in cursor: date_value = row[0] if max_date is None or date_value > max_date: max_date = date_value print("Maximum date: ", max_date) arcpy.SelectLayerByAttribute_management(feature_class, "NEW_SELECTION", date_value) arcpy.conversion.ExportFeatures(feature_class, layername_export) print("EXPORT") Both of the scripts exports all of the rows from the feature class to a new feature class. The goal is to only select and export the newest date regardless if there is 1 feature or 200 features in the feature class. As time progresses, this feature class is going to grow overtime and the next script(s) will rely on having (1) record and it needs to be the most recent record. Question, does that need to be a DATE_ONLY field type or is it okay to be a DATE-TIME field type? Not sure if this makes a difference.

‎10-15-2024

There is nothing more frustrating in working with a GDB FC/Table then dealing with a date field. I am simply trying to run a Select Layer by Attribute tool via Python to select the most recent date in a file GDB feature class in a date field type. All my research have failed in being successful. I have a Make Feature Layer and Select Layer by Attribute tool. The recent expression: arcpy.management.SelectLayerByAttribute(SURVEY123_EWO_REGULAR_HOURS_FL, "NEW_SELECTION", "date_ewo = (SELECT MAX(date_ewo) FROM SURVEY123_EWO_REGULAR_HOURS)") Presently, I have (3) entries in the Feature Layer and still the selection exports all (3) entries versus just (1). In the future, this FC is going to grow and I need to be able to select the most recent entry each time I run the tool. Appreciate any help

‎10-10-2024

Is there an example to help me on how to use Python scripting to create a printed report from a report template? I have the process complete via the Survey123 Application and Power Automate to create a PDF report from a Microsoft Word Report Template. However, due to the need to do edits/modifications on specific entries that couldn't be done thru formula(s) or coding in the XLX forms, I had to export the data into ArcGIS Pro to run processes via Python and Visual Studios. The challenge NOW is to get the modified field entries back into the overall hosted feature layer in AGOL to print the report. The work-around I am thinking of is to export the entire entry for the form and run the create report process thru a Python script. I just do not know how to start. Any help or advice? Thank You

‎10-10-2024

@AK-SavannahThomasDataProjects Thank you for adding your response(s) to this post. I was running into the exact same issue and seeing your solution solved my problems. Appreciate it

‎10-10-2024

@JoshuaClifford1 @JeffShaner We are having numerous issues with this. We have a constant internet connection, either thru WIFI or the service provider connection on the device. So, lack of connectivity is not an issue.

‎10-09-2024

I am working with a File GDB Feature Class thru Field Calculate (Python or Arcade) and trying to figure out HOW to calculate the difference between the Start Time and End Time. Example: Start Time: 7:00 AM End Time: 2:15 PM Time Difference: 2.25 How do I go about doing this? My other research results in just a flat hour or minutes and cannot figure out how to convert to the actual decimal difference. Thank You

‎10-01-2024

Thank you @RobertAnderson3 I will experiment with my flow I am trying to build to see if I can get it to work. Anything to do with a Date/Time field with Survey123 and integrating it with any other program is really really frustrating. Not sure if anyone else is having a hard time with it or if it is just me. Results: Is my function correct? addSeconds('1970-1-1',Div(triggerBody()?['feature']?['TIME CALLED']?['MM-dd-yyyy'] ,1000))

‎09-30-2024

I have been working on a flow in Microsoft Power Automate to export a submitted form to a Microsoft Excel file. The flow appears to work. However, the dateTime field type from the Survey123 Connection XLX does not export out from the form to the excel file properly. Instead of the data and time, it is just one long number. Even formatting the field type in excel, it doesn't update. Any suggestions?

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by ModernElectric

Re: Assignment Type Edit NOT working - Web Map View

Assignment Type Edit NOT working - Web Map View

Re: Power Automate - Trigger - Webhook

Re: Power Automate - Trigger - Webhook

Re: Power Automate - Trigger - Webhook

Power Automate - Trigger - Webhook

Execute DTSX from Python

Re: Select by recent date - specific date field

Select by recent date - specific date field

Python Script to Create Report

Re: Issue with GlobalID field generated in Survey123 not indexed uniquely

Re: Mobile Auto Sync not working and creating errors

Time Difference to decimal

Re: Power Automate Export Survey Excel dateTime field

Power Automate Export Survey Excel dateTime field

Re: Flow error/fail to run notification

Re: Water Utility Network - Model Blow-Off

Re: Workforce Project Sync Delay & Ongoing Issues

Survey123 Power Automate Notification

Re: Create Assignment in Line