POST
|
Yes the issue I was having was understanding how you insert feature attributes into an expression in Power Automate. I figured it out- Go to Expressions and select the formula AddSeconds. Click over to dynamic content and paste the following '1970-1-1', Div(triggerBody()?,1000) , 'HH:mm:ss' into the parentheses in addseconds() So it looks like this in the dynamic content box: addseconds( '1970-1-1',Div(triggerBody()? ,1000) , 'HH:mm:ss') insert your survey123 date field after the question mark. it will look like this in the code after you insert it: addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['dateTime'],1000) , 'HH:mm:ss') This might seem really detailed about the steps but you can't assume people know where to inset both formulas and fields from surveys. I am excited for power automate- we are already duping survey results into SmartSheet for work planning! Thank you- Renee
... View more
07-27-2020
11:45 AM
|
2
|
0
|
245
|
POST
|
n reference to this Blog: https://community.esri.com/groups/survey123/blog/2019/01/22/managing-time-and-date-from-survey123-in-microsoft-flow I can't get my date field in the right part of this code- please help!!!
... View more
07-22-2020
12:48 PM
|
0
|
2
|
272
|
POST
|
Hi Michelle, I do see that functionality but what would be more helpful is if the date field could be displayed as one field in the table view rather than having to show each part as separate fields- year, month, day. That way you could pick the date as a filter item in the table but for some reason you can't add the date field to the table. Also the field names do not truncate and it is hard to read what field is what. Thank you so much! Renee
... View more
09-04-2019
09:04 AM
|
0
|
0
|
391
|
POST
|
Greetings, I am pulling data in from four survey 123 forms- host feature layers. I am trying to build table views of the data with filters for the supervisor to be able to query specific locations and a corresponding date- then see the rest of the form data for those times/places in the table. I have tried a pre-defined filter by date but it will not save. I have to pick one date for a filter- and using the broken out fields (year, month day etc) and it does not work well at all. Any workarounds or solutions coming to provide a calendar view filter - pick a date and then see the results in the table? When/if is this functionality coming? Thank you, Renee
... View more
08-19-2019
03:38 PM
|
1
|
2
|
585
|
POST
|
Greetings, Has anyone tried to visualize Survey 123 form (tabular) data form the hosted feature service in Power BI? It sounds like the functionality is not there yet to directly view a feature layer's attribute table. Has anyone tried a workaround like developing a data export process that runs nightly so the tabular data can be displayed in a power BI dashboard? Maybe it's time to try esri Insights? Thanks, Renee
... View more
08-16-2019
08:33 AM
|
0
|
1
|
2592
|
Title | Kudos | Posted |
---|---|---|
2 | 07-27-2020 11:45 AM | |
1 | 08-19-2019 03:38 PM |
Online Status |
Offline
|
Date Last Visited |
05-06-2021
10:56 AM
|