Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About KhemAryal
KhemAryal
New Contributor III
since
01-15-2020
Monday
30
Posts created
21
Kudos given
1
Solutions
7
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by KhemAryal
|
IDEA
|
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.
... View more
2 weeks ago
|
0
|
0
|
35
|
|
POST
|
@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
... View more
07-17-2023
08:23 AM
|
0
|
0
|
668
|
|
POST
|
@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
... View more
07-11-2023
10:39 AM
|
0
|
0
|
731
|
|
POST
|
@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.
... View more
07-10-2023
10:26 AM
|
0
|
1
|
341
|
|
POST
|
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
... View more
07-10-2023
09:09 AM
|
1
|
4
|
797
|
|
POST
|
@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?
... View more
07-07-2023
07:36 AM
|
0
|
0
|
7513
|
|
POST
|
I am not able to create flow. I keep getting the error
... View more
07-06-2023
01:12 PM
|
0
|
3
|
7940
|
|
POST
|
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
... View more
02-07-2023
06:32 AM
|
0
|
5
|
2253
|
|
POST
|
@erica_poisson I had the same issue. I changed all to 'Yes' and everything working fine. No issue on the flow yet.
... View more
02-02-2023
06:54 AM
|
1
|
1
|
2309
|
|
POST
|
@Robert_LeClair Oops, I mistakenly installed the different solution. Its all good now. Thank you
... View more
12-07-2022
01:50 PM
|
1
|
0
|
730
|
|
POST
|
@Robert_LeClair Yes, I did reinstall but still could not see the tools.
... View more
12-07-2022
01:45 PM
|
0
|
0
|
731
|
|
POST
|
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?
... View more
12-07-2022
01:35 PM
|
0
|
3
|
760
|
|
POST
|
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
... View more
05-21-2021
10:04 AM
|
0
|
1
|
1236
|
|
POST
|
I signed out and signed in and now everything is displaying correctly as expected. 👍
... View more
02-02-2021
10:44 AM
|
2
|
0
|
415
|
|
POST
|
Yes I need to reflect all the features in the layer with the symbology. Otherwise I have to create more fields and individually insert domains - cleaning needed or not needed
... View more
01-29-2021
09:23 AM
|
0
|
2
|
1818
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 07-10-2023 09:09 AM | |
| 1 | 02-02-2023 06:54 AM | |
| 1 | 12-07-2022 01:50 PM | |
| 1 | 01-26-2021 02:47 PM | |
| 2 | 02-02-2021 10:44 AM |
Activity Feed
- Kudoed Multiple Inboxes for Survey123 for RobertMarros. 2 weeks ago
- Posted Re: Multiple Inboxes for Survey123 on ArcGIS Survey123 Ideas. 2 weeks ago
- Kudoed Beta opportunities now open! for JeffShaner. 10-18-2023 11:13 AM
- Posted Re: Survey123 Power Automate to Create Report "Where" clause on ArcGIS Survey123 Questions. 07-17-2023 08:23 AM
- Kudoed Re: Survey123 Power Automate to Create Report "Where" clause for VivekAcharya. 07-17-2023 08:23 AM
- Kudoed Re: Survey123 Power Automate to Create Report "Where" clause for IsmaelChivite. 07-17-2023 08:23 AM
- Posted Re: Survey123 Power Automate to Create Report "Where" clause on ArcGIS Survey123 Questions. 07-11-2023 10:39 AM
- Posted Re: Desktop Survey Submission on ArcGIS Survey123 Questions. 07-10-2023 10:26 AM
- Got a Kudo for Survey123 Power Automate to Create Report "Where" clause. 07-10-2023 09:52 AM
- Posted Survey123 Power Automate to Create Report "Where" clause on ArcGIS Survey123 Questions. 07-10-2023 09:09 AM
- Kudoed Re: Survey123 Tricks of the Trade (Live): Automate Reports for IsmaelChivite. 07-07-2023 07:37 AM
- Posted Re: Survey123 Tricks of the Trade (Live): Automate Reports on ArcGIS Survey123 Videos. 07-07-2023 07:36 AM
- Posted Re: Survey123 Tricks of the Trade (Live): Automate Reports on ArcGIS Survey123 Videos. 07-06-2023 01:12 PM
- Kudoed Automatically Refresh Inbox when Inbox Button in Selected for JAVIERVARA_SANZ. 06-16-2023 02:09 PM
- Kudoed Re: Changes to Survey123 connector in Power Automate? for KathrynCliftonGIS. 06-12-2023 10:19 AM
- Kudoed Survey123 Tricks of the Trade: Automate Your Reports for ChristieRoland. 03-30-2023 09:50 AM
- Posted Re: Changes to Survey123 connector in Power Automate? on ArcGIS Survey123 Questions. 02-07-2023 06:32 AM
- Got a Kudo for Re: Changes to Survey123 connector in Power Automate?. 02-02-2023 11:12 AM
- Posted Re: Changes to Survey123 connector in Power Automate? on ArcGIS Survey123 Questions. 02-02-2023 06:54 AM
- Kudoed Ability to Export Features within Map Viewer for fjramos. 12-20-2022 01:27 PM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Monday
|