Skip to main content

Process Improvement

In the Process Improvement topic, users can ask questions and exchange ideas about operational apps designed to help teams run processes better. Additionally, this topic covers how to trigger actions to capture value opportunities using Action Flows.

  • 117 Topics
  • 271 Replies
117 Topics
carmem.caval
Level 3
carmem.cavalLevel 3
asked in Process Improvement
Anyone now if there is a way to delete files from sharepoint using action flow?

I'm using a SharePoint connector and the Microsoft 365 module to read data from XLSX files. These files are constantly updated, and I needed a way to get rid of them after a certain time. I know that Microsoft 365 has a function to delete a table, but it deletes a sheet, not the whole file. The SharePoint module has a "Delete an Item" action, but it doesn't seem to bring the correct files. Is there a way to do this? If not, is there a way to move files from one path to another inside SharePoint, still using only Action Flow?

110
carmem.caval
Level 3
6 days ago
louis.forst11
Level 2
louis.forst11Level 2
asked in Process Improvement
Push CSV to Data Integration via Sharepoint

Hi all, is it possible to alter the push csv to Data Integration but instead of using one drive using sharepoint. I tried it but it always tells me that file cannot be found. Also the id that i have to use for the make a request in the documentation does not exist Push CSV to Data Integration (celonis.com).Thanks in advance :)

280
louis.forst11
Level 2
1 month ago
N
Level 1
nitish.kumar23Level 1
asked in Process Improvement
I want to create an action flow, when I filter the data into the views, according to the filter data action flow triggers and send only the filtered value.

I want to create an action flow, when I filter the data into the views, according to the filter data action flow triggers and send only the filtered value.

21
D
Level 1
2 months ago
R
Level 2
raman.silot11Level 2
asked in Process Improvement
Action flow tracking

Hey, I can see that we have alert subscription option for action flows. But can we get the error information somewhere for each email sent ? I am currently working on creating an action flow tracker, for which I want to track and visualise the number of emails sent with each action flow stream and what error that action flow stream faced that too. Let me know if any ideas for the same. Thank You

51
R
Level 2
2 months ago
H
Level 1
harshini.gampa12Level 1
asked in Process Improvement
ErrorFunction 'getResponseBody' finished with error! Script execution timed out after 10000ms

Error Function 'getResponseBody' finished with error! Script execution timed out after 10000ms

20
H
Level 1
2 months ago
A
Level 3
andrej.bartoLevel 3
asked in Process Improvement
Is there a way to automate granting user permissions to packages/assets (analyses, views...) via pycelonis or something similar?

I cannot utilize SCIM API in my environment, and as far as I am aware, other APIs (Audit logs, Platform adoption...) have different uses.

62
mateusz.dudek14
Level 7
2 months ago
E
Level 3
emil.vakhi12Level 3
asked in Process Improvement
Way to keep notification (performed via action flow) history and use it for filtering new notifications?

There is a case I want to solve, see below. I have a solution I would apply if I had classical programming language + RDBMS, but I'm not sure how to implement this in celonis or whether there is another solution. Could you please help? The case I want to solve is sending email notifications to users via action flow in case there are missing invoice receipts.For each missing invoice receipt there is a notification type that can be chosen with their own subjects, body text, etc., for instance:If the date1 >= today + 7 days then group 1.If the date1 >= today + 14days then group 2.If the due date >= today - 7 days then group 3. One possible solution would be to keep the history of the sent emails in some table and join it to the missing invoice receipts data to filter out the emails for each new iteration of sending - so that we don't send some letters twice if we already sent them.E.g. if we had sent the email of type for invoice receipt no. 12345 yesterday, we don't

22
E
Level 3
2 months ago
M
Level 2
m.d14Level 2
asked in Process Improvement
Hello everyone,I have an action flow that executes an API request based on the selected data in the frontend. Different users per country should only see data in the frontend and trigger the Action Flow that applies to their country. Is that pos

Hello everyone, I have an action flow that executes an API request based on the selected data in the frontend. Different users per country should only see data in the frontend and trigger the Action Flow that applies to their country. Is that possible?

25
mateusz.dudek14
Level 7
4 months ago
Q
Level 1
quen.boonzLevel 1
posted in Process Improvement
Hi Everyone

Hi Everyone We are looking into the use of Celonis for SAP SuccessFactors, is this possible and do we have any connectors available for the use case? Would also like to know what the typical event log would log like for the following modules if that is possible:EC (Employee Central)On/Off boardingSuccession planningRecruitment Thanks in advance! 

01
mateusz.dudek14
Level 7
4 months ago
P
Level 1
preethi.pottuLevel 1
asked in Process Improvement
I want to assign a value to runtime variable in Action Flow before executing it. Is this possible?1. Can we use set variables or any other module before the main action flow module which generates the output

Eg: I want to assign a value 'Category' to my runtime variable (runt_variable). previously, if the runt_variable has some other value assigned to it, I want to change it and assign it as 'Category' once this is done, the remaining action flow module has to be executed.

51
P
Level 1
4 months ago
J
Level 2
jonas.venneLevel 2
asked in Process Improvement
How to create an Array of all clerks to iterate through it with an action flow?

Hi all, i try to send a list of all open invoice to the responsible clerk.So first of all. I want to query data to get all active clerks (by an Filter). But I can't create an array out of the query. After I create the clerk array. I just itereate through it and do another data query with each iterator as filter. After that i send the list via mail. But I am failing to create the array out of the query. Do you have any ideas how to handle that situation? I think I am using the wrong bricks.  Best Regards,Jonas Vennemann

41
matt.witty13
Level 5
5 months ago
ariane.reis
Level 3
ariane.reisLevel 3
posted in Process Improvement
Hi Guys, I need some help, please!

Hi Guys, I need some help, please! I need that KPI to not change with filter in my Dash APPs, for example:  KPI Global Cycle Time : 10 DAYS With filter of manager. KPI Global Cycle Time : 5 DAYS  I need that this KPI stay still. How can I make it happen?

23
ariane.reis
Level 3
6 months ago
salma.zeped
Level 4
salma.zepedLevel 4
asked in Process Improvement
Skills vs Action Flow - which one to use?

Hi!  Is there any list or documentation on the use cases when Skills are better than Action Flow or visceversa? Thank you! 😀

104
Sverre Klein
Level 6
6 months ago
C
Level 3
conny.brintLevel 3
asked in Process Improvement
Import Github Backup via Content-Cli

Hello, We have developed a Github backup automation in the workbench based on this repo by @simon.klotz​ :https://github.com/celonis/pycelonis-examples/blob/main/pycelonis2/01_example_use_cases/01_use_case_version_control.ipynb The script was adapted to our needs so that analyses, knowledge models, variables, and transformations are assigned to the Celonis project and loaded directly into the corresponding Github repo as a backup zip. The next step is to test import the secured backups using content-cli.Is there a best practice for this?Which content-cli commands are there to upload the assets (analyses, knowledge models, variables, and transformations)? We only know of commands for pushing data pools and packages.Is there a way to import the zipped backup directly? I look forward to your contributions!Best regards,Conny

30
C
Level 3
7 months ago
siva.bahad
Level 3
siva.bahadLevel 3
asked in Process Improvement
Hello,I would like to automate the entire user access process like adding / removing/editing users and then adding users to the user group assigned.Any thoughts or leads if any of you worked on it?Thanks in advance

Hello, I would like to automate the entire user access process like adding / removing/editing users and then adding users to the user group assigned. Any thoughts or leads if any of you worked on it? Thanks in advance

22
M
Level 2
7 months ago
A
Level 3
amey.punek12Level 3
asked in Process Improvement
Create Action Flow to refresh a particular table from data model.

Hello All,We want to setup a action flow to refresh 1 table from a data model. Is there any way to do it using action flow? Thanks in advance.

63
kailash.potha12
Level 5
7 months ago
A
Level 3
ayushi.ade12Level 3
asked in Process Improvement
Hi All,I am getting an error while formatting the date in Get Rows module of action Flow.I am using below syntax{{formatDate("SALES_ORDER.REQUESTED_DELIVERY_DATE"; "DD.MM.YYYY")}}

Error: The operation failed with an error. Failed to map '0.columnName': Function 'formatDate' finished with error! 'SALES_ORDER.REQUESTED_DELIVERY_DATE' is not a valid date.

261
dennis.pflug
Level 6
8 months ago
pablo.messa11
Level 3
pablo.messa11Level 3
asked in Process Improvement
Sending Emails via MS365 Connection - Issue "[429] Application is over its MailboxConcurrency limit."

Hello Community, We have problems with the action flow when it is triggered automatically after loading a data model. The action flow is triggered several times (if the filters of the triggers are fulfilled) at the same time (see screenshot).  In the Action Flow we send an email to a specific recipient. In the action flow, we use an MS 365 connection. Due to this "parallel" triggering, the connection reaches a limit and issues the error "[429] Application is over its MailboxConcurrency limit.".  Microsoft has set the limit for concurrent requests to 4. Have you had a similar problem? Have you solved the problem? Thank you very much!Pablo

112
pablo.messa11
Level 3
8 months ago
V
Level 3
vincent.freemLevel 3
asked in Process Improvement
How can we modify the output of the 'Create CSV' module?

The 'Create CSV' module allows you to specify which columns will appear in the CSV file by selecting them in the 'Aggregated fields' I would like to know how we can rearrange the columns of the Create CSV module (e.g. 'Document type' is always the first column output in the file, would like to move this to the 5th column)  The Create CSV file also will show commas ( , ) instead of decimal places when showing a calculated field (e.g. Throughput Time column in the Create CSV file shows 35,29 days instead of 35.29 days - I cannot see a way to alter this)

41
B
Level 1
9 months ago
S
Level 2
saivishalreddy.gurijLevel 2
asked in Process Improvement
I want to capture the Username of the logged person when executing the action flow. How can I achieve that?

I want to capture the Username of the logged person when executing the action flow. How can I achieve that?

43
mateusz.dudek14
Level 7
10 months ago
gregor.schei11
Level 2
gregor.schei11Level 2
asked in Process Improvement
How to grant permissions to packages via pycelonis?

We would like to automate permission management via PyCelonis. Is there a way to grant access to a package for a group or a user via PyCelonis? Thank you 

54
gregor.schei11
Level 2
11 months ago
tushar.konde
Level 3
tushar.kondeLevel 3
posted in Process Improvement
Ayushi Ade

Ayushi Ade5 months ago Actions for this Feed Item CommentHi Marco,I have already created an ML workbench to create/save as an excel file and send via skills and this is working properly. In one of your solution you have develop this can you please tell me how you develop this cause i am looking for same solution for my use case if you have any screenshots for it please share so it can be helpful for me 

10
tushar.konde
Level 3
11 months ago
P
Level 3
pavan.bhara13Level 3
posted in Process Improvement
Hello @1460018848​ ,

Hello @1460018848​ ,  I am looking for a similar concept where i need to trigger an action flow when another one finishes. Where you able to achieve this? it would be really great if you could share some insights or guide me through some documentation that you may have looked into :)  TIA!

00
P
Level 3
11 months ago
J
Level 4
joyce.cardo12Level 4
asked in Process Improvement
I want to create a filter in PQL that gives me only the POS >90 by the end of the current month.

SELECT TO_DATE(    TO_CHAR(ADD_MONTHS(CURRENT_DATE, 1), 'YYYY') || '-' ||    LPAD(TO_CHAR(EXTRACT(MONTH FROM ADD_MONTHS(CURRENT_DATE, 1)), 'FM00'), 2, '0') || '-' ||    '01',    'YYYY-MM-DD') AS FIRST_DAY,DATE '2023-12-01' - INTERVAL '1 DAY' AS END_OF_THE_MONTHFROM "CRM_VBAK";

11
J
Level 4
11 months ago
T
Level 3
teun.gilis11Level 3
asked in Process Improvement
Is it possible to use a dropdown menu when using Actions to trigger an Action Flow?

Hi all, With Automation Skills, it is possible to update an Augmented Attribute with a dropdown list using Actions. The action button triggers an Automation Skill which updates the Augmented Attribute. I would like to migrate this action from Automation Skills to Action Flows, but I'm unsure about how to include dropdown values in an Action Flow. Anyone that knows how to do this? Thanks,Teun

01
S
Level 1
11 months ago

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2024