Arek Maziarczyk

Check if COLLATE Polish_CS_AS instead of COLLATE Polish_CS_AI. I also did not catch the problem, but if there is any concernig polish letters you can also use the dbo.RemoveDiactrics function, which removes polish letters. It should be available in your version. It works like this: SELECT @re

To check if user is in a certain source/table you can do inner join by login, BPSid, etc., or left join with null filter. But SQL you have beedn already given is all you need. You can add two actions of assignin task and run them on condition that there are BPS users or not. For example, Action 1

Check if UPN format is appropriate. Maybe you will need other credentials like including domain name etc. For example, insead of 'jan.kowalski@companyname.pl' sth, like jkowal@intranet.domainname.com.pl. Check what is assigned as COS_BPSid, and what fields are used in "sychronisation configuration".

If there is no user returned by SQL command or rule that you used then you will get the error on the path starting subflow. It depends also on what type of step you use (system steps does not need to assign tasks). Source of your user list does not matter. You can use BPS users, AD or Azure for exam

Yes, those actions. Don't use "for each" operator on the path. "Run subflow" action will start one subflow for every row from your list. Tasks need to be assigned within subflow, not in the main flow. You can do this also in path configuration >> https://kb.webcon.pl/akcja-utworz-zadania/ https:/

You do not need to use "for each operator" .There is an action "run subflow" that you can use on the path. Use this action and pass all the information from subelements list. Action will start new flow for each row. After you pass all necassary info (people also possible but not neccessary) you will

There are few options: 1. Width can be set in 'general prperties' of each column (use pixels or percentage) 2. High can be limited in 'Advanced configuration' of subelement list 3. JS actions (pthose predifined or script) or set as form rules in 'Style and behavior' bookmark of specific attribute

You can use dbo.Calendars table. There is [CAL_IsWorkingDay] column which shows workin/nonworking days. Then add two fields on your form to input date range, and 'sql row' or 'sql grid' attribute to calculate number of dates. Date attributes should be put ias string value in ' '. Use SQLs below. Ot

Just as Jacek said... SELECT det_id. And to be more specific, it is good to use sql grid.

I suggest to make a view or views that will aggregate the necessary data from your tables. It will be more efficient to do that dicertly on database or DWH than in BPS. Then you can use it easier, as a separate data source, in SQL grid or SQL command in studio.

Is there any ID or sign tha you can use to recognize the type? If not you can try to read documents and use scripts (ex. python) that recognize languages, or try to use AI libraries. You can also try to use chat GPT modules to recognize language. Possible solution make.com with chat gpt. In all of t

The rule that you showed below uses the information from the form directly. To walidate you need to get information already saved in database. You need do add action with SQL on the path. The action has to take range of dates and places as conditions in your SQL. Notice that action that walidates su

There is the dbo.Calendars table in BPS where you can define all weekends and working days. Configured in "System configuration".

Why do you still use v. 2021 ?

Hello, it would be nice to have an option of inserting a "CAML command" similarly as it is done with "SQL command". It would help in setting conditions and checking the outputs of sharepoint actions.

Hi, I have the same problem. When I use "Remove list item" action there is error message which shows how many rows were found and after clicking "close" all rows are deleted. I don't mind what is the point of this message. I use the following query: Anyway, I have also

Has someone met the problem with "Giving privileges" action, after update to v. 2022.1.4.127? Action stopped matching user data on "DisplayName" (COS_DisplayName) or ID that is stored as BPSid (COS_BPSid). Finding user is now possible only by email address (COS_email). COS_BPSid and COS_email are no

It was first installation, so completely new instance of studio. There was no demand of creating data base or sql server etc. Installation run from link received by email with already provided link to portal.

Hello, Did enyone meet a System.NullReferenceException after installing Webcon trial version 2022.1.4.111? Error occurs from the first run of studion so it is not possible to do any activity, creating appliction, proces and so on. Another error tha occurs simultaneously i System.InvalidOperation