This is a centrally managed app for handling inquiries from web forms and phone calls. The system accepts queries from Microsoft Forms \/ Google Forms. After the response is complete, the data is automatically uploaded to SharePoint Online lists (Microsoft Lists) via Power Automate.<\/div><\/div>\n\n\n
<\/span>Workers (Number of swimlanes: 4)<\/div>\n\n\n\n
\n- <\/i><\/span><\/span>Employee<\/strong>\n
\n- An employee reporting an inquiry.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span><\/span>Inquiry Contact Leader<\/strong>\n
\n- Responsible for the inquiry response team.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span><\/span>Inquiry Responder<\/strong>\n
\n- Person in charge of responding to inquiries.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span><\/span>Translation\/advice<\/strong>\n
\n- Person in charge of translating and advising.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n
<\/span>Workflow (Workflow diagram complexity: 29)<\/div>\n\n\n\n
\n- <\/i>1<\/span><\/span><\/span>1. Open a Ticket<\/strong>\n
\n- The employee provides input about the query.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>6<\/span><\/span><\/span>2. Nominiate Responder<\/strong>\n
\n- The person in charge of the inquiry response team designates a responder.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>13<\/span><\/span><\/span>3. Response<\/strong>\n
\n- The person handling the inquiry enters the response.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>14<\/span><\/span><\/span>3b. Translation\/advice<\/strong>\n
\n- The designated person(s) will translate and advise.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>19<\/span><\/span><\/span>4. Evaluation of response<\/strong>\n
\n- The person responsible for the inquiry response team evaluates the results of the response.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>3<\/span><\/span><\/span>9. Completed Response Form<\/strong>\n
\n- Employees enter questions that have already been answered by phone.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>37<\/span><\/span><\/span>x1′. Title<\/strong>\n
\n- The workflow platform sets the subject line.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>8<\/span><\/span><\/span>x1. Title<\/strong>\n
\n- The workflow platform sets the subject line.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>9<\/span><\/span><\/span>x2. Destination<\/strong>\n
\n- The workflow platform sets the recipient to whom the response email is sent.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>10<\/span><\/span><\/span>x3. Email Response Text<\/strong>\n
\n- The workflow platform sets the response email statement.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>29<\/span><\/span><\/span>x4. Inquiry File Base64 Conversion<\/strong>\n
\n- The workflow platform converts the query file to Base64.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>30<\/span><\/span><\/span>x5. Answer File Base64 Conversion<\/strong>\n
\n- The workflow platform converts the answer file to Base64.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i>23<\/span><\/span><\/span>x6. JSON Preparation<\/strong>\n
\n- The workflow platform prepares the JSON data to be sent to Power Automate.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n
<\/span>Business app variables to be passed (number of data items: 37)<\/div>\n\n\n\n
\n- <\/i><\/span> \u25bc Contact Information \u25bc<\/strong> <\/span>
0<\/code> <\/li>\n\n\n\n- <\/i><\/span> Name<\/strong> q_name<\/span>
1<\/code> <\/li>\n\n\n\n- <\/i><\/span>Company Name<\/strong> q_company<\/span>
2<\/code>\n\n- The name of the company from which the inquiry originated is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Email Address<\/strong> q_email<\/span>
3<\/code>\n\n- The email address of the inquirer is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Phone Number<\/strong> q_tel<\/span>
4<\/code>\n\n- The phone number of the inquirer is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Previous queries of note<\/strong> q_note<\/span>
5<\/code>\n\n- Past queries of special note regarding the query source will be stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span> \u25bc Inquiry Form \u25bc<\/strong> <\/span>
6<\/code> <\/li>\n\n\n\n- <\/i><\/span>Received Date<\/strong> q_receiveDatetime<\/span>
7<\/code>*<\/span>\n\n- The date and time when the inquiry was received is stored.<\/li>\n\n\n\n
- processInstanceStartDatetime<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Inquiry ID<\/strong> q_id<\/span>
8<\/code>*<\/span>\n\n- #{#sformat(‘%d’, processInstanceId)}#{#sformat(‘%04d’, processInstanceSequenceNumber)}<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span> Inquiry Type 1<\/strong> q_kind1<\/span>
9<\/code> *<\/span><\/li>\n\n\n\n- <\/i><\/span> Inquiry Type 2<\/strong> q_kind2<\/span>
10<\/code> <\/li>\n\n\n\n- <\/i><\/span>Product Features<\/strong> q_function<\/span>
11<\/code>\n\n- Product functions related to the inquiry are stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Inquiry Details<\/strong> q_inquiryDetail<\/span>
12<\/code>*<\/span>\n\n- The details of the inquiry are stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Inquiry Related Files<\/strong> q_inquiryFile<\/span>
13<\/code>\n\n- Files related to the query will be stored. (only one file)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span> \u25bc Response Details \u25bc<\/strong> <\/span>
14<\/code> <\/li>\n\n\n\n- <\/i><\/span>Response Method<\/strong> q_media<\/span>
15<\/code>\n\n- The method of responding to the inquirer is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Operator<\/strong> q_operator<\/span>