Latest Contributions by AmyRoust

‎11-04-2022

I use Power Automate to send email notifications when someone submits a Survey123 form. I have three total. Two continue to work just fine; the third stopped working several months ago and I'm just now noticing it. I had to recreate the flow from scratch to get it to work again. I have no idea what caused it to fail, and since I don't know when it failed, I can't attribute it to a Survey123 or Microsoft update. Has anyone else had a Power Automate flow with Survey123 stop working without any notification? I'm looking for any clues as to the cause. Here's what I can tell you: - Survey was created with the web app. - Survey was set to Use the version the survey was published with (3.13). - One of the other surveys that still has a working flow was created with the web app, but it was set to Always use the latest version. It was originally created in version 3.15.

‎11-01-2022

Thank you - this is the clue that I needed. I was getting a null value in both formulas without realizing it. Once I fixed the bad reference to another field, it worked.

‎11-01-2022

Looks like others have had similar issues to this, but I'm not finding a solution to my version yet. I have two notes fields that are doing simple calculations based on values from other fields. Here is a sample: ${Ravg_after}*${Kavg_after}*${LSavg_after}*${Cavg_after}*${Pavg_after} In the Connect desktop application, it calculates as expected: When I try it in a web browser, I get NaN: I tried adding a round function since it had so many decimal points, but no luck. What am I missing?

‎10-27-2022

Oh my gosh, yes! Thank you so much! Breaking it apart fixed the problem. You are my hero!

‎10-27-2022

I'm working on a really complicated Survey123 Connect XLSForm and have hit a roadblock. Everything works until I introduce this question: type: note name: Ravg_before label: Ravg Before appearance: horizontal calculation: if(pulldata('BMPMod_Chart','ChangeBefore','PracticeName',${practice})='None',pulldata(${LandType_Before},'Ravg','County',${county_bmp_location}),pulldata(${LandType_Before},'Ravg','County',${county_bmp_location})*pulldata('BMPMod_Chart','MultiplyBefore','PracticeName',${practice})) When I fill out the form inside Survey123 Connect, I get the correct result: But when I publish the survey and open it in a web browser, I immediately get this error message: I realize that this is really hard to troubleshoot without providing the XLSForm and the related media files that drive all of the lookup values. I'm just hoping for some clues that might get me across the finish line without having to call tech support. Things I've tried: Ensured that all column names in all CSV files in the media folder have no spaces or special characters. Ensured that every record in every CSV in the media folder is fully populated (no null values/empty cells) Renaming the two CSVs that have a - in their file name to remove the - I have not removed the underscore from the CSV called BMPMod_Chart because I am successfully calling that CSV and returning values in earlier questions without error. Any other ideas on what I can try? I don't know what the web browser is checking that the desktop app is not.

‎10-26-2022

Fantastic! Thank you!

‎09-16-2022

Experience Builder allows you to add REST URLs as a data source, which is nice when you don't need or want a separate map just to make your data available to ExB. However, when you use a service as your data source, the table widget does not honor the integer formatting. I would like to have the ability to remove commas and decimal points from integer fields directly in the Table widget, rather than having to create a web map, configure the pop-up, and then use the web map as the data source. For my use case, I have an int field that contains years only. The year 2,022 looks odd!

‎08-31-2022

We are using the infographics tool in Business Analyst to make custom infographics for each county in our state. (Current products can be seen here: https://maps.kdhe.state.ks.us/ksephtcountyprofiles/). At the bottom of our page, we have three pie charts that list the top five chemicals released to air, water, and land. Currently, the only way we have to set the color scheme on a pie chart is to assign a unique color to each chemical (similar to what you would do in Symbology in a map layer). However, with 100+ possible chemicals, it often happens that the top five for a given county are assigned really similar colors. We would like to have the ability to set the color scheme so that it is the same five colors regardless of which five chemicals rise to the top for a given county. Perhaps there could be an enhancement for the "top x" functionality that allows you to set the colors at a global level rather than assigning them to a specific attribute value?

‎08-31-2022

In the current Map Widget for ArcGIS Experience Builder, your choices for setting the initial zoom scale are to either use the web map's setting or set a "custom" zoom with an interactive map in a modal window. Zooming in and out goes by the basemap's preset zoom levels and there is no way to enter a custom scale or "zoom to layer" to get a custom extent that fits your unique geography. I would like to have a way to set a custom extent, either by zooming to a layer's extent and/or by entering a custom scale.

‎08-04-2022

In the Filter widget, when you set up your SQL expression, there is an option to create a dropdown menu with all of the unique values in a given field (the Unique option). I would like to have the option to turn off the "All" option because I have a use case where it doesn't make sense for the user to see all of the data at once. Right now, my only option is to do predefined unique values, but there are 105 counties in my list and the builder does not seem to want to add more than 30 or so records.

‎07-21-2022

I just created a line chart that shows total cases of West Nile Virus by month. Unfortunately, there is no way to sort in month order if my field names are text fields. My choices are to either sort the months alphabetically or by the case count. Neither makes sense - we want to show the summer peak in cases. For now, I will use the month numbers, but that's not as friendly to the public. If there were a way to add in aliases, that would resolve the issue.

‎07-19-2022

In this ArcGIS Pro query layer, one of my field names turns blue/purple: When I publish the layer in a web service, it gets quotes around it: The quotes are causing issues with related tables. Why do they appear, and is there any way I can get rid of them? I've tried adding AS [Level] as an alias, but the quotes still appear in the service.

‎06-29-2022

Just want to add my voice to the chorus that not being able to start/stop services in Pro is highly desirable. My latest workflow where that would be handy: I need to make a minor modification to a feature class that is in a dataset with several other feature classes. I have 6 services that I need to stop so that the dataset is unlocked. They are in different folders and on different pages in Server Manager. Instead of just selecting them all and stopping them, I have to find and stop them one at a time in Server Manager. Then, once the change is made, I have to hunt them down and restart them. The downtime for my web services is longer with Server Manager than it would be in Pro. I get the sense that Esri has a philosophical difference of opinion on this and really wants everyone to go through Server Manager. If that's the case, then they need to enhance Server Manager so that you can find, stop, and start multiple services at the same time. Maybe even build in a Server Manager pane that you can open in Pro? It would be better to have it all in one place than to have to go to two different applications to accomplish a simple task.

‎06-23-2022

I just checked the site that I had the issue on - the table is still displaying times and I don't see a button to suppress that or honor the SmartForms settings. As far as I know, this enhancement has not been implemented.

‎06-15-2022

Just wanted to add my "me too" sentiments to this idea. I have inspectors who do site visits and take a lot of photos. When they come back to the office, they want the option to reorder the photos so that they are grouped logically and support the overall narrative of the report. It would be great if we could just add a field in the data that they could modify later to determine the order of adding photos to the report. Then they could just sequentially number the records in the desired manner and run the report.

Online Status	Offline
Date Last Visited	4 weeks ago

My Ideas

Latest Contributions by AmyRoust

Power Automate send email flow stopped working

Re: Calculation works in Connect but not web app

Calculation works in Connect but not web app

Re: FormLogicError: Could not evaluate...

FormLogicError: Could not evaluate...

Re: Enhance pie chart color configuration options for "top five" lists

Allow number formatting in Table Widget

Enhance pie chart color configuration options for "top five" lists

Improve zoom level customization options

Allow user to suppress "All" value in Filter widget

Improve Sort Options for Chart Widget

Meaning of blue/purple text in query layer

Re: ArcGIS Pro functions for map services

Re: Hide time in Table widget

Re: Sort repeats in Survey123 feature report

Re: Map pop-ups run off the edge of the map; Featu...

Provide an option to turn off "Use In Field Maps" ...

Re: Hide time in Table widget

Allow "Update Data" on hosted feature layers for u...

Make Delete Attachments tool compatible with branc...