I recently found myself in a situation, when I needed to calculate a date difference between two datetime values in Power BI excluding weekends. The request seemed first as an easy thing, until I found out, that Power BI doesn’t have any function allowing to achieve it easily.(more…)
This post is a “how to” tutorial, showing how can a data from SQL Server table be loaded into a “Repeating section” control in Nintex Forms. Needless to say, having that data inside the control allows then to manipulate it and treat each row as a single record, thanks to the possibility of saving contents of the control as XML.(more…)
PowerApps is getting more and more powerful tool to create business apps in the “no-code” approach. Using SharePoint as the data source is somehow natural (although there are alternatives, like an SQL Server or Common Data Service) thanks to their tight integration.(more…)
Ever wondered how to display SQL table inside your Nintex Form? Indeed, there is the “SQL Request” action, but it only allows you to show data from database as a dropdown, list of options, etc… and always – just a single column.
Have you ever been struggling with a lack of the possibility to clear a number, person or lookup column using PowerApps? Well, I recently found myself in a situation, where I needed to be able to clear such columns in my application, but found out, that this is not possible (maybe not yet).
Building an intranet using modern SharePoint I was asked by a customer, if this is possible to show information from their facebook @workplace portal. I started digging and reading the documentation only to realize, that no matter if I were using modern or classic approach, still there are no ready-to-use scripts from facebook, allowing to copy-paste and then be able to display ex. information from Newsfeed.
This may seem trivial, but if you want to create a Flow, that is parameterized, where a name of a group and list of members is passed as the request parameters then it turns out it is not that straightforward.
In Microsoft Flow there is a set of actions, that allow to work with Office 365 Groups. There is also one dedicated to adding new members (only “Members”. There is no way currently to add “Owners”).
Recently my customer asked me to create a dashboard, to monitor completion of tasks in a workflow. The idea was to highlight completed, on track and overdue tasks with different colors. First I thought about using SharePoint list with Modern Experience, and column formatting. But then I was asked, not only to highlight rows for tasks, but also their grouping header – as there were many tasks created per each group of tasks and the customer wanted to see status of a whole group ad-hoc, without a need to drill down.
I recently was asked a question: how can I use the signature from the Nintex Mobile inside a document being generated by the Generate Document action? Unfortunately this is not yet feasible only using Nintex products. This is because Nintex Workflow for Office 365 is not handling correctly the binary data (it loses null bits) so what I proposed was to use Microsoft Flow.
The Nintex Xchange conference in San Diego has just finished. Although I haven’t had the opportunity to be there myself, our community is sharing fast still hot news from the event. I decided to put them in order facing my personal interests.