search results

(...) face with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two column s 'Country ID' (Choice column from table Country) and 'City' So in City table, we have one foreign key that shows on Country table. Issue: (...)

(...) nums.FormFieldTypes.TextSingleLine)] public string DataOdn { get; set; } } In Run() I put records from an external system to Lista_Poz. In Designer Studio I have created Items List with column s like in Nagl_OT. When I call my action in the workflow I get an error:Invalid cast from 'System.String' to 'WebCon.SAP.CustomActions.NaglowekOT+Nagl_OT How should I implement Items List in my solu (...)

(...) https://community.webcon.com/posts/post/starting-workflow-from-the-sharepoint-document-library/54 I've did all the same configurations as the document to try to get it working but my Start BPS column is not displayed. The json code that is in the post needs to be formatted and my final version (for my case) is: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column -formatti (...)

(...) using MS Flow (now called Power Automate) but when I need to configure the Get Token Action I only have the options in the picture and they are premium. Anyone with ideas? Using the json in the column of the item list is not working. Thank you!

(...) Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the column s with the column s from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicin (...)

(...) Hello all!! Does anyone configured a rule where the action goes on each row of an item list and if a row has option A for a specific column then column B cannot be empty? There are some new functions for the item list but they only work as form rules and for action (even creating a business rule, form rules don't work as it needs to a TRUE/FALSE result). Even using SQL Command I think it would (...)

(...) match (=) is 2% of the query cost. Due to the very high yield for the environment (large BPS instances), I propose to create a new type of selection attributes, where we give up filtering, and for column s intended for searching, we will add an additional search method parameter to the database: LIKE%, %LIKE%, exact match (=).

(...) Hello, I am using an itemlist to show some data to the user. In some cases, the list contains over 50 elements. Because it also has a lot of column s, it is very hard to follow sometimes. I would like to at least make the table header sticky. How can I do that? Thank you in advance! Best regards, George

(...) Hello Community! I have a simple question (at least I think so). Is there a way to make a report that does only show certain column s and DOES NOT link to the details? I have a business delegation process and would like to allow everyone to check who's delegated and when. I do not want everyone to be able to check details of delegation, costs, etc. And clicking on a report row allows me to go to the deta (...)

(...) le to loop over all rows of an excel file? I have an excel file with employees information(say 50 rows of employees). I want to navigate through each row, read and populate data in my form from excel column s and then trigger a workflow for each employee.

(...) Hi. I'm looking for a solution to hide rows of a list element depending on the value of a list element column . I.e. for a task list I would like to have the row visible for everyone, until the checkbox "done" ist set "true". I tried with the "Acceptance" function (see Acceptance.png), but the issue is that I can make the column visible for a (single) defined user, but not for multiple users. Any ideas (...)

(...) EST Designer Studio. When you save a process using the REST designer studio unset translation of changed objects are saved as a blank string instead of null. This may lead to empty Step and Form Type column s in reports and other objects using internal views. If you are already affected by this you can decide whether to wait for a fix or update translates table. update [Translates] set TRANS_Name = nu (...)

(...) application, I will create a blog post for this. Source and exported application: https://github.com/Daniel-Krueger/webcon_reportSubscriptions Attachment: Because of sensitive information I blurred column s in the report screenshot and the table in the mail. Best regards, Daniel

(...) m/forum/thread/555/46 having been removed in 2021.1.3.143 (tested, worked fine), something similar is happening in 2021.1.3.163 when you use a picker field in an item list, and map it's data source-column s into other column s of the item list. It then throws: "b.map is not a function"-error, see attached screenshot. If I dont map data source column s to other column s it doesn't throw an error.

(...) I have the scenario, where i keep e-mail address and other informations in an itemlist. Now i need to send e-mails for each recipient in the itemlist. The e-mail contains informations from other column s in this list. By having three entries in the itemlist, there would be three e-mails with different content to be sent. Currently i'm thinking about creating a simple workflow to send an e-mail. The wo (...)

(...) urce configuration. After updating to version 2021 R3, all REST data sources configured in versions older than 2021 R1 will cease to function. Data sources configured in 2021 R1/R2 will only return column s from a collection that have been manually selected, whereas previously they would load all column s without needing to select them individually. For a data source to return column s from a collectio (...)

(...) Validation rule using SQL. I have an item list that is populated with lines if the user select a Sales Order in another field or manually filled if there is no information on the SO. There is a column that is mandatory to be filled whenever the item list has any rows and I tried many examples to construct a validation form rule in order to have information on that column . I was using a SQL quer (...)

(...) might be a controversial one when it comes to performance, but sometimes it could be quite useful to be able to bring that value in reports. Some of that sometimes could also be done with calculated column s in reports, but it could be easier I suppose.

(...) Hello all, Does anyone configured a calculated column in the reports to calculate the difference between current date and a date field from the form? I was trying days (getdate() - form field) but it's not accepting the days formula. Thank you!

(...) Hi all, I'm out of ideas... I've tried everything that came to my mind without achieving the desired result. Is it possible to have a hyperlink column in an Item List that shows the Preview and only after clicking on the little icon on the right (see attached image) it opens the full form?