Trying to export csv file using Flow designer but in the Append delimited file action through error

BRINTHAM
Tera Expert

BRINTHAM_0-1785274758423.png

I am trying to export a CSV file using Flow Designer, but I'm encountering an error in the "Append Delimited File" action. why this error is troughing? 

 

4 ACCEPTED SOLUTIONS

Ankur Bawiskar
Tera Patron

@BRINTHAM 

did you check docs about that spoke features?

is that a paid one?

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

Hi @Ankur Bawiskar 
 Create schema • Australia Workflow Data Fabric • Docs | ServiceNow 
I have referred this doc. could you please check it, what is the issue I am facing?

View solution in original post

@BRINTHAM 

looks like paid one so we can't explore.

seems the action is not getting the proper inputs and hence failing.

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

Hi @Ankur Bawiskar 
I am working on a catalog task and need a solution for the following scenario. The approvers are required to approve the catalog task, but they do not have read access to the task. We are creating approval records for the respective approvers and sending them an email notification to take action. However, since they cannot access the task, they are unable to understand why the approval was requested. Currently, they would have to communicate via email to get the required details. Is there a way to include the relevant ticket details directly in the email notification using Flow Designer, so the approvers have the necessary information without needing additional communication?

 

View solution in original post

8 REPLIES 8

Hi @Ankur Bawiskar 
I am working on a catalog task and need a solution for the following scenario. The approvers are required to approve the catalog task, but they do not have read access to the task. We are creating approval records for the respective approvers and sending them an email notification to take action. However, since they cannot access the task, they are unable to understand why the approval was requested. Currently, they would have to communicate via email to get the required details. Is there a way to include the relevant ticket details directly in the email notification using Flow Designer, so the approvers have the necessary information without needing additional communication?

 

@BRINTHAM 

the email which goes can include the task details such as Short description etc

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar 

Yes, we need to include catalog variables such as Short Description, Description, Application, and other relevant details in the email.

 

I tried exporting the data from the sc_item_option_mtom table and attaching the generated Excel file to the email notification. I attempted to use the Utility actions in Flow Designer for this, but they are not accepting the required input fields.

 

Could you suggest a feasible approach to export the data from the sc_item_option_mtom table to an Excel file using Flow Designer and attach it to the email notification?

@BRINTHAM 

you can include the data of variables directly in email by using GlideRecord

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader