Latest Contributions by elpinguino

I've put together a dashboard which includes a map of building assessments. We've gone into the reassessment phase now, and they want the dashboard to only show the latest reassessment points now. I'm sure there is a way to do this in arcade- maybe a filter by or intersect? Multiple points (assessments) sit within a polygon parcel. Or maybe I'm really blanking and there's an even easier way to do it? The project was set up in an emergency scenario, so we didn't get related tables set up if you're wondering. Just want the green arrow dot to show within this parcel. Not the others.   Sorry if I've posted in the wrong section. Wasn't sure where this question would best fall under!   ... View more

Hi there, I haven't signed into my Hub site in a while, but noticed today that the more info panel/sidebar has reappeared. I have multiple cards on the homepage that you can click on and then that opens an individual experience builder in a new tab. I thought I had disabled the metadata/ grey info box as I haven't seen it for a while, but possibly something happened since the latest update? I did try in the settings to toggle off embedded app. It removes the metadata/grey box, but it also removes the header/banner which I want to keep. I want the user to feel like they are still in the same website/hub. I've put screenshots below of what I mean. If possible I would not like the grey box or any of the metadata accessible. The users want/need a simple interface. They get easily distracted and don't need to know the metadata details. Not to sound grouchy, but just wanted to provide a little context as to why I think it shouldn't be there. Thanks in advance for your help.     ... View more

Hi Automaters, Context I have a Flow set up so whenever a record is submitted from a Survey123 a new row gets added into an Excel spreadsheet table in Sharepoint. From previous ESRI forum postings I've found this expression for converting the date/time into my desired format.   addseconds('1970-1-1', Div(triggerOutputs()?['body/feature/attributes/TargetDates'],1000) , 'dd/MM/yyyy')   Problem However there's another problem. The date/time question in the survey sometimes gets answered. It isn't required, and it's not always necessary. From the Flow error feedback I gather I need to add in a null if statement similar to the below format, but with my lack of coding experience I can't figure out how to combine the two. I'm getting an invalid expression when I try to combine them.   if(equals(triggerOutputs()?['body/feature/attributes/InspDate'],null), 'No inspection date recorded', convertTimeZone(addSeconds('1970-01-01',div(triggerOutputs()?['body/feature/attributes/InspDate'],1000)),'UTC','Pacific Standard Time','D'))   I found the above expression here - https://community.esri.com/t5/arcgis-survey123-blog/managing-time-and-date-from-survey123-in-microsoft/bc-p/893399#M205. Error feedback from Microsoft Automate - https://learn.microsoft.com/en-US/troubleshoot/power-platform/power-automate/getting-errors-null-fields Is it possible to add a Condition Connector with Null expression at the start of the flow? The field is Null sometimes though, not always. I wonder if there are better/easier/more simple ways to get to my end goal. Either way the above are what I've found so far, but am not sure how to combine them. Possibly I could break them into two connectors like format any incoming date/times at the start or check for nulls, but still let them pass through at the start? ... View more

Hi S123ers, I keep circling back to this article, but it doesn't exactly answer my question I think... https://community.esri.com/t5/arcgis-survey123-blog/dates-and-time-in-survey123/ba-p/895528 This here really bothers my team. They want to see the date as DD/MM/YYYY when they are filling out the form. What I gather from the linked article is that a) there has to be a second/new field created to calculate the desired date time format. You can't do it in the same field. b) that still doesn't fix the problem of the date appearing in the wrong format at the time the user fills out the survey, only afterwards. How do I fix this? Is it something I control on my computer locale or agol locale? I'm working in Survey123 connect. The user accesses the survey on the desktop via web browser. ... View more

Hi, Wondering if anyone has any thoughts on how useful/worthwhile it is to get the Premium licence in Power Automate to access ArcGIS. I'd really like to use the Get data from feature layer in ArcGIS Online and export it to a CSV file template (https://make.powerautomate.com/environments/Default-90d78e6a-0431-4d5f-916a-d3ab9c1a0bd9/galleries/public/templates/6b1e4d293f3442d2b551af87ee8108b0/get-data-from-feature-layer-in-arcgis-online-and-export-it-to-a-csv-file), but not sure how much the upgrade would cost and if it is worth that for the organisation or if other people have found ways to do the same process without a premium licence. ... View more

Hi community, I've just gotten access to Microsoft Automate. I used to set up automations with Make/Integromat. I've set up a flow so every time an S123 record gets submitted a row in an Excel table gets updated in Sharepoint. Because I'm new to Microsoft Automate I wondered if there's anything I should be wary of? Like would is there the possibility it will eat up a lot of credits because the layer is always being watched? Or does anyone have any good videos, templates or resources they recommend for Automate/ESRI users? ... View more

Hi ExB Community, Does anyone know how the table widget decides which fields are default ticked for initial display? I was wondering if there is somewhere to control this before even entering the table widget because I have a lot of fields and the real estate for scrolling through this area is minimal. It can be quite tedious setting this bit up. It would be great to see if the interface could be made easier to organise the order the fields appear in too.   ... View more