Latest Contributions by KhemAryal

‎07-23-2024

@KansasDASC You need survey123 connect where you can create survey from your feature service. Once the survey is published, you can create feature report from Survey123 online. If you are not familiar with Survey123 Connect then you may use ArcPro and data driven pages as a report

‎07-23-2024

@KansasDASC I had this done in the past as workaround. After collecting data in the field maps, create a survey from the feature service of your field maps data. Then, use a survey123 template to generate all the reports.

‎04-10-2024

This will definitely be a great feature if made available. Not necessarily multiple inboxes required but options of multiple folders to list the related surveys inside the inbox will fulfil the need.

‎07-17-2023

@VivekAcharya You Rock. I was able to get the flow success with the solution you provided. And yes, any SQL questions in the future will be tagged on you 🙂 @IsmaelChivite You are right as the solution was more from Power Automate. Thank you

‎07-11-2023

@IsmaelChivite I am sure you have the answer for my question above if this can be DONE or NOT? I tried multiple SQL syntax at Where Clause, nothing worked. I appreciate your time. Thank You KA

‎07-10-2023

@ClaireField As far as I know, Survey123 Connect doesn't let you submit. You need to publish from the connect once you get "data is valid" (that means the survey form is all ready to publish) and test from the Survey123 desktop app (not the connect app) or mobile/browser.

‎07-10-2023

I am struggling with Power Automate Survey123 create report to get the results only for the previous month. As it can be done easy for the last x days but I want for the last month. I tried different SQL syntax in 'Where' clause. I can do for last 30 days or any number of days but not all the months are 30 days. There should be an easy way to do it but I kept failing. any suggestion? BETWEEN CURRENT_TIMESTAMP - 30 AND CURRENT_TIMESTAMP successfully creates a report with results for the last 30 days. But I need to create report for previous month automatically to create a report every month. Thank you in advance

‎07-07-2023

@IsmaelChivite You are right. Report was not created in the output as I did not put correct syntax at Where clause. what would be the 'Where' clause syntax if I just want to see the records for the last month. I can do for last 30 days but not all the months are 30 days. There should be easy way to do it but I kept failing. any suggestion?

‎07-06-2023

I am not able to create flow. I keep getting the error

‎02-07-2023

I suggest to go to the 'Connection' from 'Data' menu. Click on 3 dots beside it and select Switch Account. It will prompt you to sign in. Once you sign in or allow connection. you will see the surveys populated. I hope this solves your problem

‎02-02-2023

@erica_poisson I had the same issue. I changed all to 'Yes' and everything working fine. No issue on the flow yet.

‎12-07-2022

@Robert_LeClair Oops, I mistakenly installed the different solution. Its all good now. Thank you

‎12-07-2022

@Robert_LeClair Yes, I did reinstall but still could not see the tools.

‎12-07-2022

After upgrading to ArcGIS pro 3.0.2, I don't see the utility solutions for CCTV Manager. The geoprocessing tool should have contained 'Import Access Table' and 'Generate Pipe Features' tools. Any Idea?

‎05-21-2021

I have a map displaying over 4000 features, each with unique IDs. Out of these 4000 features, I need to display only 250 features with selected unique IDs. Is there a short formula to display only those 250 features. List of features id : 1964004 1444000 1719002 1452034 1618000 1602002 2004000 1175000 2012000 1172002 1946000 continues to 250 ids Expression I used: var mh = $feature.UNITID; if ((mh=="1964004")||(mh=="1444000")||(mh=="1719002")||(mh=="1452034")||(mh=="1618000")||(mh=="1602002")||(mh=="2004000")||(mh=="1175000")||(mh=="2012000")||(mh=="1172002")||(mh=="1946000")){ return"selected"; } else { return""; } This works as intended but I am wondering if there is a short expression where I can just copy the list rather than typing each features in the bracket Thanks KA

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by KhemAryal

Re: Looking for suggestions on PDFs and FieldMaps

Re: Looking for suggestions on PDFs and FieldMaps

Re: Multiple Inboxes for Survey123

Re: Survey123 Power Automate to Create Report "Where" clause

Re: Survey123 Power Automate to Create Report "Where" clause

Re: Desktop Survey Submission

Survey123 Power Automate to Create Report "Where" clause

Re: Survey123 Tricks of the Trade (Live): Automate Reports

Re: Survey123 Tricks of the Trade (Live): Automate Reports

Re: Changes to Survey123 connector in Power Automate?

Re: Changes to Survey123 connector in Power Automate?

Re: CCTV Manager for ArcGIS Pro 3.0.2

Re: CCTV Manager for ArcGIS Pro 3.0.2

CCTV Manager for ArcGIS Pro 3.0.2

Arcade expression for displaying only selected features

Re: Changes to Survey123 connector in Power Automa...

Re: Looking for suggestions on PDFs and FieldMaps

Survey123 Power Automate to Create Report "Where" ...

Re: Changes to Survey123 connector in Power Automa...

Re: CCTV Manager for ArcGIS Pro 3.0.2