Is it possible to use readexcelsheet() function within an interface?

Question

Hi
I am wondering if it is possible to use the readexcelsheet() function on a rule input file (ri!Submission.submissionfile) which is uploaded in the same interface.
a!textField(
      label: "Rules",
      labelPosition: "ABOVE",
      value:
        readExcelSheet(    
          excelDocument: ri!Submission.submissionfile,    
          sheetNumber: 1,    
          startRow: 9,    
          numberOfColumns: 4  
        ).result.values[1,4],
      saveInto: ri!rules,
      refreshAfter: "UNFOCUS",
      readOnly: true,
      validations: {}
    )
Should this be possible or does the function only work within a process model?
In the interface I am getting the following error: 'Interface Definition: Expression evaluation error at function 'readExcelSheet'' while in the process model it works (with process variables)

Thanks in advance!
Chris

pedro.simoes · Answer

Hi Chris,

The document that you want to uses needs to exist in Appian DMS and actually saved in a folder for you to use that function. That only happens when you submit a form... In the same interface and without any form submission, you can't do it. You can try to build your Interface to validate if upon submission the flow should go back into the interface itself or continue to other process model nodes.

Sign up

Login with SSO

Login to the community

Login with SSO