Latest Contributions by erica_poisson

Hi -  I am having a type mismatch issue with some time calculations. I have an existing survey XLSForm which is formatted like this...the calculation works perfectly. The number of minutes elapsed is returned. In this instance, the user is prompted to enter two times in this format - XX:XX and then the third line determines minutes elapsed.  erica_tefft_0-1638303251938.png I want to modify the survey to do some behind the scenes calculations so that field staff do not need to enter the colon (:) between hours and minutes (we want the time to be entered like XXXX). I've modified the XLSForm to do this, and now my line 48, "Time_Elapsed" is throwing a type mismatch error. I can not figure out what I've done wrong as I feel like the results of line 43 (Interview_TimeColon) and line 47 (StartFishing_TimeColon) are not all that different from what was being input in the first 2 lines from the screen capture above (e.g. 10:45 vs. 1045, which is then calculated to 10:45).  erica_tefft_1-1638303251939.png Things I have tried -  changing 'type' column to calculate for all intermediate calculations (lines 41 to 43 & 45 to 47) changing bind::type column to 'time' for lines 43 and 47 (second screen capture) changing bind::esri:fieldType to 'null' for all intermediate calculations changing bind::esri:fieldType for line 48 from integer to string to no bind::esri:fieldType changing bind::esri:fieldType to 'date' for lines 43 and 47 Does anyone have any suggestions? I also did test using the solution from this post, but it did not work.  Thank you, ... View more

Hi, I have a Data Expression that I am using in my Dashboard to help me create a graph that shows average use by day of week for three separate locations. I am unsure if this is actually providing me with the correct values, and was hoping someone can look this over to see if what I am doing makes sense / is actually right. Any help refining this would also be really helpful, as I'm sure this is not elegant.    var portal = Portal("https://www.arcgis.com"); // Group the features by the BLA var BLA = Filter(FeatureSetByPortalItem(portal,"xxx",0,['BLA_Used', 'Survey_Date', 'Name'],false), "NOT Name = 'Rental%'"); var groupBLA = GroupBy(BLA, ["Survey_Date"], [ { name: "BoatLaunchArea", expression: "BLA_Used", statistic: "MIN" }, { name: "cntBoats", expression: "BLA_Used", statistic: "COUNT" }, { name: "date", expression: "Survey_Date", statistic: "MIN" }, ] ); var combinedDict1 = { fields: [ { name: "sdate", type: "esriFieldTypeDate" }, { name: "dow", type: "esriFieldTypeInteger" }, { name: "BLA", type: "esriFieldTypeString" }, { name: "cntSurveyScans", type: "esriFieldTypeInteger" }, ], geometryType: "", features: [], }; var i = 0; for (var m in groupBLA) { combinedDict1.features[i] = { attributes: { BLA: m["BoatLaunchArea"], cntSurveyScans: (Floor(m["cntBoats"] / 2)), sdate: DateDiff(m["Survey_Date"], Date(1970, 0, 1), "MM/DD/yyyy"), dow: Weekday(m["Survey_Date"]), }, }; i++; } var dict1 = FeatureSet(Text(combinedDict1)); var groupDOW = GroupBy(dict1, [ { name: "dow", expression: "dow" }, { name: "BLA", expression: "BLA" } ], [ // { name: "BLAName", expression: "BLA", statistic: "MIN" }, // { name: "surveydate", expression: "sdate", statistic: "MIN" }, { name: "countBoats", expression: "BLA", statistic: "COUNT" }, ] ); var combinedDict2 = { fields: [ { name: "BoatArea", type: "esriFieldTypeString" }, { name: "wday", type: "esriFieldTypeInteger" }, { name: "avgBoats", type: "esriFieldTypeInteger" }, ], geometryType: "", features: [], }; var x = 0; for (var n in groupDOW) { combinedDict2.features[x] = { attributes: { BoatArea: n["BLA"], wday: n["dow"], avgBoats: (Floor(Average(n["countBoats"] / 2))), }, }; x++; } return FeatureSet(Text(combinedDict2));   One additional note...towards the bottom for 'avgBoats', I have divided by 2 in addition to using 'Average' because each boat is scanned twice - once when launching and once when coming off water. I wanted to divide by 2 so each boat is only counted once, and then Average what was left.  erica_tefft_0-1637700499212.png Here is a sample of the output: erica_tefft_0-1637700290493.png Any help would be appreciated!   ... View more

Hi -  Cross-posting from ArcGIS REST API question board...see original version here. I am using this blog from @AaronPulver to create webhooks in Power Automate for a Field Maps workflow. Currently, I am attempting to set up a webhook that generate an email when a new record is added to a related table - this portion works perfectly. What I really want to do is also return the attributes from the point feature it is related to so that I can include one of the attributes in my email notification.  Looking at the Extract Changes documentation, I see that I should be able to include "includeRelated=true" to return the related record, however I am unsure of where to add this query in.  I have attempted to include this at a variety of locations without luck. Currently I have included this within the "Check Status" HTTP request...the Flow runs, but attributes from the related record are not returned. I have also attempted to include this under "Get Edits" and "Get Edits Redirect" also with no luck.  Any suggestions would be appreciated!     Erica ... View more

Hi -  I am using this blog from @Anonymous User to create webhooks in Power Automate. Currently, I am attempting to set up a webhook that generate an email when a new record is added to a related table - this portion works perfectly. What I really want to do is also return the attributes from the point feature it is related to so that I can include one of the attributes in my email notification.  Looking at the Extract Changes documentation, I see that I should be able to include "includeRelated=true" to return the related record, however I am unsure of where to add this query in.  I have attempted to include this at a variety of locations without luck. Currently I have included this within the "Check Status" HTTP request...the Flow runs, but attributes from the related record are not returned. I have also attempted to include this under "Get Edits" and "Get Edits Redirect" also with no luck.  Any suggestions would be appreciated! erica_tefft_0-1637597143751.png   ... View more