Flow failing - ArcGIS Survey123 to Excel spreadsheet in Powerpoint

(0) Share

Report

Posted on by arcgis_epro

Hi there, I am new to Automate. This is one of my first flows.

What the flow does

The user fills out a form in ArcGIS Survey123. When they hit submit that causes the flow to run. Based off of the answer to the OperationNumber question in Survey123 (conditional connector) Microsoft Automate knows which spreadsheet to write into in Sharepoint. A new row is added into a table in the spreadsheet.

The problem

I have about 20 different OperationNumbers . They all run fine without a hiccup except for two which always make the process fail, and I can't figure out what the issue is. I have about 8 of these Condition connectors set up all exactly the same except for OperationNumber it asks for within the flow.

These are the errors.

I clicked on some of the help links offered on the right hand side, but wasn't able to solve the problem probably because I don't understand enough about Automate and how it works.

I tested the user workflow myself and filled in all the question fields. There weren't any null fields.

Categories:

Using connectors

All responses (4)

Answers (0)

Sort by

GdarmonAbra 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

you need to use an additional expression (test on null value) on the div expression you are using somthing like this

if(equals(<VALUE TO TEST>,null),0,'value if not null')
arcgis_epro 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GdarmonAbra , I am still not skilled up enough to be able to fully replicate what you are explaining. Could you show me? Do I add this right after the Survey123 Connector - When a survey response is submitted? Is it a condition?
This is what my current set up looks like.
GdarmonAbra 77 on at

Like
a
(0)

Report
Copy link

Link copied!

you need to change your div expression on the "add a row into a table" excel action into something like this:
variable name - "VAR"
from
div(VAR,2)
to
div(if(equals(VAR,null),0,VAR),2)
arcgis_epro 21 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @GdarmonAbra , Thank you for your reply. I've added my expression below. I am getting confused because I also have to convert the output into a different time format. Targetdates is the variable. I also don't have a ,2 at the end of my expression.

What I am currently using
addseconds('1970-1-1', Div(triggerOutputs()?['body/feature/attributes/TargetDates'],1000) , 'yyyy/MM/dd')

Am I trying to do too much in one step? Should I break it into two? First if statement, and then convert to desired date/time format? Is that possible to break into two? Or are you able to advise on how I can nest it further into the expression?

Maybe a better question is what exactly is my variable?
Is that
'body/feature/attributes/TargetDates' triggerOutputs()?['body/feature/attributes/TargetDates']

This is the original post where I got help converting to the desired date/time format.
https://powerusers.microsoft.com/t5/Building-Flows/Survey123-to-Excel-Date-time-format-showing-as-pound-sign/td-p/2175994