Latest Contributions by erica_poisson

I was able to resolve this - there were two issues. First, within my data expression to get the Average Private Launches per Day of Week, there were two things wrong.  The filter expression in line 4 was incorrect and I needed to update it to say "NOT Name like 'Rental%'" instead of "Not Name = 'Rental%'".  The count from line 16 is really the count of total survey scans - I need to drill this down to the number of boats. Since each boat has 2 surveys completed each day (for launch/retrieval), I needed to divide this value by 2 in line 31.    var portal = Portal("https://www.arcgis.com"); // Group the features by the BLA var BLA = Filter(FeatureSetByPortalItem(portal,"###",0,['BLA_Used', 'Survey_Date', 'Name'],false), "NOT Name like 'Rental%'"); // group by boat area and date, return count of launches i.e., boat count var groupBLA = GroupBy( BLA, [ {name: "the_year", expression: "EXTRACT(YEAR FROM Survey_Date)"}, {name: "the_month", expression: "EXTRACT(MONTH FROM Survey_Date)"}, {name: "the_day", expression: "EXTRACT(DAY FROM Survey_Date)"}, {name: "BLA", expression: "BLA_Used"} ], [ { name: "survey_count", expression: "BLA_Used", statistic: "COUNT" } ] ); // empty feature array var features = []; // iterate over grouped featureset to populate array for (var g in groupBLA){ var wday = Weekday(Date(g['the_year'], g['the_month']-1, g['the_day'])) var feat = { attributes: { BoatArea: g['BLA'], wday: wday, boats: g['survey_count']/2, wday_label: Decode(wday, 0, 'Sunday', 1, 'Monday', 2, 'Tuesday', 3, 'Wednesday', 4, 'Thursday', 5, 'Friday', 6, 'Saturday', '') } } Push(features, feat) }; // pass feature array into dict var outDict = { fields: [ { name: "BoatArea", type: "esriFieldTypeString" }, { name: "wday", type: "esriFieldTypeInteger" }, { name: "boats", type: "esriFieldTypeInteger" }, { name: "wday_label", type: "esriFieldTypeString" }, ], geometryType: "", features: features }; // convert dict to FeatureSet return FeatureSet(Text(outDict))     Next, within the data expression to get the Count of Private Launches by Day of Week, I needed to correct the Filter expression in line 5 the same way I did above. I also commented out some redundant lines within the GroupBy statement on line 7.    var portal = Portal("https://www.arcgis.com"); // Group the features by the BLA var BLA = Filter(FeatureSetByPortalItem(portal,"###",0,['BLA_Used', 'Survey_Date', 'Name'],false), "NOT Name like 'Rental%'"); var groupBLA = GroupBy(BLA, ["Survey_Date", "BLA_Used"], [ //{ name: "BoatLaunchArea", expression: "BLA_Used", statistic: "MIN" }, { name: "cntBoats", expression: "BLA_Used", statistic: "COUNT" }, //{ name: "date", expression: "Survey_Date", statistic: "MIN" }, ] ); var combinedDict = { fields: [ { name: "sdate", type: "esriFieldTypeDate" }, { name: "dow", type: "esriFieldTypeInteger" }, { name: "BLA", type: "esriFieldTypeString" }, { name: "cntSurveyScans", type: "esriFieldTypeDouble" }, ], geometryType: "", features: [], }; var i = 0; for (var m in groupBLA) { combinedDict.features[i] = { attributes: { BLA: m["BLA_Used"], cntSurveyScans: (m["cntBoats"] / 2), sdate: DateDiff(m["Survey_Date"], Date(1970, 0, 1), "MM/DD/yyyy"), dow: Weekday(m["Survey_Date"]), }, }; i++; } return FeatureSet(Text(combinedDict));     This resulted in consistent and verifiable results when comparing data between the data expression and Excel: BLA 1 – Private Launches, Saturday AVG serial chart = 18 AVG Excel = 17.88 ... View more

With the help of a co-worker, I have successfully returned related records using an adapted version of @AaronPulver 's blog (see above for link) for using Power Automate with a feature service/Field Maps.  Following Aaron's blog up until the Get Edits Redirect step (housed within the Check Status Until Ready step), we then deviate and use the following workflow to retrieve the related records of the table that the webhook is associated with. Basically the goal is this - a new record is submitted to a related table; within my webhook, I want to also retrieve the parent feature information to use within an email notification.          ... View more

With the help of a co-worker, I have successfully returned related records using an adapted version of @Anonymous User 's blog (see above for link) for using Power Automate with a feature service/Field Maps.  Following Aaron's blog up until the Get Edits Redirect step (housed within the Check Status Until Ready step), we then deviate and use the following workflow to retrieve the related records of the table that the webhook is associated with. Basically the goal is this - a new record is submitted to a related table; within my webhook, I want to also retrieve the parent feature information to use within an email notification.      ... View more