Howdy….lets say I want to send a team a daily report of what completions happened only yesterday.
I know that I have these functions:
I can change the enrollment date back to all dates - but to achieve what I am describing - is that doable as shown???
I think the closest you can get natively is doing what you have and switch the 1 to a 0 so it gets yesterdays data, and then include the completion date column and sort by it so yesterdays are first?
This is a limit I’ve run into often for reports based on relative dates, you really want relative ranges which are not really offered. I end up doing like a filter often based on the report, i.e. email the report to my automation email, process the data and filter out what I don’t want, and form into a new doc that gets emailed to others, or going all in API wise and building my own report essentially.
I agree with
Here’s an “out of the box” thought...
If you want to do something with more options, you could create a webhook that triggers for every course completion, and then use an automation tool to write the completions out to the data repository of your choice. In our case we write them into a SharePoint 365 list where we have some other automation through PowerAutomate, but you would get better performance from Airtable or a database. Once you have the data in a suitable repository you can query it any way you like, trash items over X days old, etc.
I agree with
Here’s an “out of the box” thought...
If you want to do something with more options, you could create a webhook that triggers for every course completion, and then use an automation tool to write the completions out to the data repository of your choice. In our case we write them into a SharePoint 365 list where we have some other automation through PowerAutomate, but you would get better performance from Airtable or a database. Once you have the data in a suitable repository you can query it any way you like, trash items over X days old, etc.
I probably need to start a new thread just on Office 365 and Docebo. 
We are using SharePoint to perform some other work on the completions for certification purposes. Essentially what we’re going to looking for combinations of courses completed that earn one of our certifications. That workflow is triggered every time a new completion is recorded.
On a related note, we are also using a SharePoint list to capture the audit logs. Once a month another process batches them up into a monthly CSV file. Eventually he length of the list in SharePoint will likely get too long, and I’ll have to move those items to a real database if I ever want decent performance in making queries.
Lastly, we are using a combination of things to automate the entry of sessions and events into Docebo. We’re using a SharePoint datasheet with lookups on existing classes and locations for the data entry. Then it all gets processed into sessions and events (something harder than it should be). One thing I haven’t found a good way to do in PowerAutomate (for “free”) is connect directly to the Docebo API with Oath2 and manage the tokens properly. For all API calls into Docebo I’m currently passing info by webhook to Integromat. If you know of a way to get PowerAutomate to work better directly with the Docebo API, I’d love to know!!!
Ah yeah, so I’m doing a lot of those types of processes too. In Power Automate you can make a custom connector where you define the oauth setup and then you build out actions or triggers by defining the docebo api, so you essentially get new building blocks, works seamlessly and you can share it amongst users of your O365 tennent to leverage the build. Essentially it gives you the power of docebo connect/workato but within the office 365 ecosystem. Have built 4 custom connectors with different scopes for docebo and use them across about 75 power automate flows for managing lots of actions and activities quickly outside of the inbox scope.
I probably need to start a new thread just on Office 365 and Docebo.
We are using SharePoint to perform some other work on the completions for certification purposes. Essentially what we’re going to looking for combinations of courses completed that earn one of our certifications. That workflow is triggered every time a new completion is recorded.
On a related note, we are also using a SharePoint list to capture the audit logs. Once a month another process batches them up into a monthly CSV file. Eventually he length of the list in SharePoint will likely get too long, and I’ll have to move those items to a real database if I ever want decent performance in making queries.
Lastly, we are using a combination of things to automate the entry of sessions and events into Docebo. We’re using a SharePoint datasheet with lookups on existing classes and locations for the data entry. Then it all gets processed into sessions and events (something harder than it should be). One thing I haven’t found a good way to do in PowerAutomate (for “free”) is connect directly to the Docebo API with Oath2 and manage the tokens properly. For all API calls into Docebo I’m currently passing info by webhook to Integromat. If you know of a way to get PowerAutomate to work better directly with the Docebo API, I’d love to know!!!
Check out here
done many more things since then, but an overview
Wow love the chat
I hate that we are running away from the UI for a solution for something that should be straight forward, but some of this brings along some very insightful methodology. Sometimes I put a feeler out there to see if someone has pulled it off successfully to save a cycle on reporting - and I am a little surprised - but maybe noone has actually pulled it off yet.
We are expanding our sharepoint site and O365 footprint this year. I think that will bring along the opportunity that I have been waiting for with Power Automate and PowerBI.
But
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
