Hi @SeanKMcGinnis -
We've finally had the ArcGIS Connector added into our Business Connectors and I have begun my testing. I've had the flow successfully run, but my condition is evaluating as False and not triggering my email notification. I am hoping you can advise on this.
EDITED!
Here is the beginning of my Flow:
Initial - config in screen capture below no longer used.
Updated to - this removed the configurations within Available fields, Comparison type and Search parameter value and added an additional statement to the Where clause to make it much more specific:
After getting the data from a feature layer, I use Apply to each with the following configuration:
Within the Convert File Complete Date, my Base Time is set to be:
addSeconds('1970-1-1', Div(items('Apply_to_each')?['attributes']?['File_Complete_Date'], 1000), 'MM/dd/yyyy')
Within the Compose (Calculate 45 days from File Complete Date), the Input is set to be: addDays(body('Convert_File_Complete_Date'),int(45),'yyyy-MM-dd')
My Condition is set to be equal to utcNow:
I have some questions/concerns about why this might not be working as expected:
1. utcNow... to me this means date and time, however my data is really only configured to have a date (all time are defaulted to 12pm). Could this be why the Condition evaluates to False for all?
2. When the Flow runs, I see 1,000 iterations within Apply to each (see below) - could the test record just not be reached? When I bring my feature layer into a map and apply my query, I have 3,172 records which meet my criteria (Application_Status = App Complete AND File_Complete_Date IS NOT NULL)
I have addressed this by altering my Where clause to be much more specific - I probably should have known to do this from the beginning!
3. When I look at the raw data from the ArcGIS Connector Outputs, I do not see my test record included; I have searched by it's unique file number using Find and it does not come up.
I will continue testing to see if I can solve this. I will attempt to make my Where query in the ArcGIS connector more specific so I return less records than I currently am (#2 above). If you have suggestions in the meantime, I would appreciate anything you have.
I think I have solved this... I do have a question however... even after reading the documentation, I am unclear what the Available Fields, Comparison Type and Search Parameter Value is supposed to be doing within the "Get Data" connector. Could you elaborate on what these should be used for?
Thank you!
Erica