Latest Contributions by MiltonSolano

‎04-13-2023

Just to reply to my question myself: I went with ESRI support services and the quick solution was to recreate the hosted feature class from the XLSX file. After that, the very same custom report template that was failing to generate worked again with no issues at all. It was a faster solution rather than keep looking for what happened to the previous hosted feature class. Mjss25

‎04-13-2023

Hi Folks, I have one question whose answer I couldn't find on the documentation about the search capabilities: I need to populate a select one with the content from one field (Search_String) but the search expression must query two fields: Search_String and Trip_Type. A query like this: Search_String = 'BCI - Gamboa | 16-04-2023' AND Trip_Type = 'Public' Is this possible? My search statement is: search('Disponibilidad?url=https://services2.arcgis.com/HRY6x8qt5qjGnAA9/arcgis/rest/services/Vista_Horario_de_Botes_Complementarios/FeatureServer/0&orderByFields=Fecha_Hora_String DESC', 'startswith', 'Search_String', ${Search_Exp}) The above Search_Exp contains the string 'BCI - Gamboa | 16-04-2023' and it works, but I need to filter based on Trip_Type as well. Is it even possible? Mjss25

‎04-07-2023

Hi Folks, I'm going crazy trying to make my reports work again. They were working fine, till I modified some attributes on the custom template. The source of the error seems to be the map setting. If I remove the map tag, the report get generated just fine. In my custom template, I have this line to make my map show: ${Poligono_Vuelo | map:"588eb299f5b346fcb4143621060c0888" | size:400:300} Which is a geotrace polygon. The error I receive is (see attached screenshot): An error occurred while generating reports. An error occurred when rendering by the report engine. Failed to print map for ${Poligono_Vuelo | map:"588eb299f5b346fcb4143621060c0888" | size:400:300}. Connection timed out after 120000ms I tried changing the map to another public vector map with no success. I even tried the very basic map option: ${Poligono_Vuelo | size:400:300} with no success at all. What is wrong? It was working but now isn't. The problem is the generating the map image on the report. How can I debug the problem? Thanks!

‎03-30-2023

Thank you @ZacharySutherby for taking the time to answer. It sounds more like a hack than a proper solution. What about if I need to search in a range of dates? Or search after a specific time frame within a date? Using strings is not possible. None of the search samples uses date datatype as filter. The date datatype is key in searches and the hack you mentioned probably work but it requires a little bit more overhead to work properly. Anybody has other ideas? Milton

‎03-25-2023

Hey @Paulvan_Heerden1 You need to use a Compose data operation first in order to use the properly formatted date. Then use this formula in PA: addseconds('1970-1-1', Div(triggerOutputs()?['body/feature/attributes/YOUR_DATE'],1000) , 'dd-MM-yyyy') Here's how I did it: Fecha Seminario is the Compose data operation, and the formula is: addseconds('1970-1-1', Div(triggerOutputs()?['body/feature/attributes/seminar_date'],1000) , 'dd-MM-yyyy') Then, on the Send an email notification step, I used the output date from the compose operation. I hope this works for you. Milton

‎03-25-2023

Hi Folks, I'm building a survey for boats reservations where our users will select from a list of available schedules (Date-time) from another survey to register. I can search for the available scheduled dates using the Search() function. The returning string is an epoch time. See the attached screenshot. My question is: how can I format this date to show it as a regular Date-time value? This is how I'm retrieving the available dates: What function should I use in the appearance column? I tried using format-date or decimal-date-time functions with no luck. Is this even possible? Cheers, Milton

‎03-13-2023

Hi Folks, I have the same question: it doesn't matter what you write in the Point zoom Scale, the value is ignored and the zoom goes all the way to 1:10 for each point! As Randy mentioned, is way too far to be useful. How can we fix this?

‎02-11-2023

Hey @IsmaelChivite , I checked all the files you posted here and the documentation page, but for the life of me I can't find how to implement the "Count records in a table or layer" functionality. How did you do the count? Are you using a separate table or the same survey table? Please, help me to better understand how to accomplish this. Thanks! Milton

‎02-04-2023

Folks, I agree is a very needed functionality, specially with those dashboards containing table data ONLY (no map), so no way to setup refresh rate for those tables. Is great us under consideration, please move forward to implemented! Thanks, Milton

‎01-31-2023

Hola @IsmaelChivite , gracias por la respuesta casi inmediata y por dar seguimiento a esta funcionalidad. I supposed these are the only ways exposed to attach the report: upload and then getting the file back to attach it to the message OR use the HTTP module. Definitely, the HTTP module is out of the equation because is a premium feature. The other option is to write down on the email body the URL to retrieve the PDF by clicking on it. I'll work on some solutions based on these options. A big thanks to the team behind Survey123 for making this new Create Report Action in PowerAutomate! Milton

‎01-30-2023

Hi Folks, I just noticed there's a new Create Report action in Power Automate. I just used it on one of my flows to generate a custom report. It seems to work pretty nice but I don't know how to grab the resulting PDF document and attach it to the email (I can grab the URL to the PDF, but I need to attach the PDF itself.) Here's the documentation for the new thew Create Report action: https://learn.microsoft.com/en-us/connectors/survey123/#create-report I just simply can't find how to attach the resulting PDF into the email. See the attached screenshots with my current flow in PA. Can someone help me to figure out his one? Milton

‎01-12-2023

Hi @RobertAkroyd1 , I think this feature is already implemented in the web form editor. I haven't tested yet, but I guess it fixes the old problem with erasing previous data. See this screenshot: This checkbox should fix the problem reported. I have not fully tested yet. Milton

‎11-16-2022

Thank you @DavidAnderson_1701 , This will work on ArcGIS Pro environment but I need a way to do it in ArcGIS Online, using Notebooks. Thank you for taking the time to answer. Milton

‎11-15-2022

Hi Community! I hope I'm posting on the right forum, if not, help me pointing out the right one. I have a team capturing Tree locations using Field Maps. These trees have decimal degrees X, Y positions already captured on the fields. I need to automate the calculation for UTM_X and UTM_Y fields for the new trees captured and I would like to setup a Scheduled task in ArcGIS Notebook Script to update these field at the end of the week. Another person from the team export these new trees using a view to an excel spreadsheet for further processing. Can you help me with the basic python code to start doing this (if it is possible of course). Right now I have to do it in ArcGIS Pro. Milton

‎11-10-2022

Great, I'll be there looking closely the Report Generation from MS Power Automate.

Online Status	Online
Date Last Visited	6 hours ago

My Ideas

Latest Contributions by MiltonSolano

Re: Report fails with Error Connection timed out

Select one with Search with filtering two attributes..

Report fails with Error Connection timed out

Re: How to format Date-time results from Search() function...

Re: How to format the date from survey to display it as DD/MM/YYYY in Power Automate Reports

How to format Date-time results from Search() function...

Re: Point Zoom Scale ignored for zoom action

Re: Survey123 Tricks of the Trade: pulldata("@layer")

Re: Auto refresh Operations Dashboard

Re: Attach custom report from Power Automate...

Attach custom report from Power Automate...

Re: Maintain Field Values Hidden with Conditional Visibility

Re: Calculate UTM positions using Python?

Calculate UTM positions using Python?

Re: Survey123 Sneak Peek Live Session planned for November 29, 2022

Re: Lag in Copy and Pasting Text Elements in Layou...

Re: Generated Note Causing Publishing Issue

Re: Issue with query parameter not working in sear...

Re: 'Feature isn't Valid' error for Field Maps on ...

Re: Imagery Layer not shareable with the public...