Latest Contributions by DaveK

Hello,  I have a survey built through Survey123 Connect that I'm connecting to MS Power Automate to set up auto generated emails when a survey is submitted. The survey contains repeats that I would like to include within the emails. Currently, if I add the repeat field into the email it sends an email for each repeated record. I would like a single email to contain all of the repeat information. As soon as I add the repeat to the email, Power Automate adds an "Apply to each" function. Is it possible to include all of the repeat information within a single email? Any help is appreciated.  Thanks.  ... View more

Hello,  Is it possible to extract the Approximate Distance that's returned via the Near Me widget in a WebApp Builder? I know that the Screening tool gives the ability to download similar data to the Near Me but it doesnt seem to include the approximate distance to the initial point like the Near Me does. Any help is appreciated.    Thanks.  ... View more

Hello,  I'm working on a survey using Survey123 Connect. I have a table which includes water system names and accompanying information (ID, treatment plant name, facility no, etc). I would like to allow the user to select a specific water system using a select one dropdown and then have the remaining information auto populate in text fields below it. The issue I've come across is that there are duplicate system names with differing information (treatment plant name, facility no, etc). An example of my table is attached below.    So far I've been able to use a select one to choose my water system and a pulldata function to bring back the PWSID number for that system. I then use a choicefilter which allows me to select from a list of filtered Treatment Plant Names based on what was selected in the System Name. The issue I come across is then pulling back the Facility ID no. I cant seem to figure out how to bring that back. Is there a simpler way to achieve what I'm trying to accomplish?  Any help is appreciated.  Thanks.  ... View more

Hello,  I'm creating a survey in Survey123 Connect which contains a select multiple question type. I'm using numeric codes for the choice names and standard text labels for the front end selection. I'd like to have these labels returned within a hidden text field so I can then view the labels instead of the codes for future use in dashboards or other apps. I'm using this calculation expression jr:choice-name(selected-at(${layerlist}, 1), '${layerlist}') found via this post - https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-list-no-save-label/td-p/1138198 I noticed that there is a choice index number within the expressions which specifies which selection to return. I would like to return all of the select multiple selections and not just a single choice. Is it possible to return all of the choices? If so what would I input in the choice index section of the expression? Any help is appreciated. Thanks,  ... View more

Hello,  I recently came across an error when trying to plot coordinates from a CSV within a webmap. I'm adding a CSV file that's hosted by another organization and is being added as a layer from the web. When I try to bring the layer in I'm prompted with this message:  The spreadsheet contains lat/long coordinates that need to be plotted. Does this process require credits?  Thanks.    ... View more

Hello!  I have a survey that is used for field data collection. The first question in the survey is "Report Type" which then displays relevant questions based on the report type selected. We would like to use the built in report function within the Survey123 web backend, but I would like to know if there is any way to have a specific report template exported based on the chosen report type?  For example if we have 4 report types - A,B,C,D, I would like to have 4 report templates made which include the specific relevant fields which were in the survey. Is there then a way to run the reports and have them automatically populate the proper report template types based on the Report Type field?  Thanks. ... View more

Hello,  I have a collaboration set up between my AGO and internal Portal environments. I've successfully shared hosted services between portal and ago previously, but came across an issue when sharing a service with layer views. The layer views are used for data collection and feed back into the main service. The main service has the appropriate settings enabled like Sync but it wont appear in the Portal group after syncing. Do the layer views associated with the service need to have Sync enabled as well?  Thanks.  ... View more

Hello,  I'm working to create a collaboration between our Portal and our AGO within my organization. We would like to have the data within the collaboration be referenced as opposed to copied. The goal of this project is to have users in the field collect data to the service within the collaboration which would sync back to our enterprise through the Portal. I have gone through the setup process and am able to see the service I shared from my Portal within my group within AGO. The issue comes when I try to open the layer in a webmap. The map prompts me for my Portal login. Is this typical behavior for a referenced collaboration? Is there any way to not have the user be prompted to login to view the data if they are a member of the group its shared to in ago?  Thanks.  ... View more

Hello,  I have a notebook within AGO that prints all the public facing content within my organization. The results are formatted to be comma delimited to make it easy to import into an excel spreadsheet to share. Is it possible to directly export the results of this script to an excel file?  Thanks.  Script:  from arcgis.gis import GIS gis = GIS("home") from IPython.display import display my_content = gis.content.search(query="owner:USERNAME",max_items=10000) #item_types_need = ['Web Map','Web Mapping Application','StoryMap','Dashboard','Web Experience','Form'] item_types_need = ['Feature Service'] for item in my_content: if item.type in item_types_need: if item.content_status == "public_authoritative": author = "Authoritative" else: author = "None" if item.shared_with['everyone']== True: print(""'"{}"'",{},{},{}".format(item.title,item.id,item.type,author)) #display(item) print("Completed")   ... View more

Hello,  I'm using the FeatureSetByRelationshipName to pull related table records into a popup. One of the fields (SumOfReturnMG) being pulled is an integer field and I need to round the number to 2 decimals. What would be be best way to format the field within my existing Arcade expression?  Expression user below var fs = FeatureSetByRelationshipName($feature,"qry_HUC_USEGROUP_RET" , ['*'], false); var result = ""; var cnt = Count(fs); if (cnt > 0) { // start loop through related records for (var f in fs) { // for each f (=feature) in related features, add attendee to the result result += TextFormatting.NewLine + f.YearNumber + TextFormatting.NewLine + f.SumOfReturnMG; } } else { // overwrite result with text to indicate that there are no attendees result = ""; } return result; Resulting record (field highlighted in blue) Thanks.   ... View more