WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > User profile Andreia Correia > Forum messages

Andreia Correia

User

Rest API for Sales Force
24.08.2023 17:02

Hello, Does anyone has a rest api configured to access Sales Force? I have a connection and I use it in a process but I'm getting the data from Opportunities. I would like to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data/v52.

Calendar
04.08.2023 12:15

Hi Mario, I've accomplished that by using a Sharepoint list and a flow on Power Automate. Not sure if that can be a possibility to you

It worked! Thank you for your kind help :)

Non-working days vs Country
10.07.2023 16:59

Hello all, Does anyone knows or have configured something that can relate the country vs national holidays in the country? Like having the calendars for Portugal Holidays, Spain, etc I know that we have to manually insert the holidays in the System configuration for calendar's table but in thi

But using the BPS view as the source, if I filter by the step, I only see the request that is in the start step for the requester chosen.

Hello all, Is there any way to use the same data table field but having different filters in each step? For example, on the start, I want the info to show request's open for the requester In the approval step, I want to check the request's for the project code belonging to the approver Is

Hello all, Does anyone configured a validation rule and/or control field where you need to check if the lines added in a item list were already added in another instance? I have a process for overtime registration and I want to block the user to add a new instance with dates that were already

Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my tabl

Item list bulk update
30.05.2023 09:43

Hi Daniel, Very interesting what you configured in the process, however I'm not sure if that would be an option because the user will need to open line by line. The main idea is, the user might need to migrate costs from one Project to another, in that way the lines may vary from 2 to 200. So it

Hi, I'm assuming you're writing the email in a column on your field, if not, you need to change your field to picker option and in the config window, copy the email field into a form field in the workflow. My query is getting users from a item list as an attendee list: select distinct FORM

Hi, I have you tried to also select the form type? Can you paste your SQL?

Item list bulk update
26.05.2023 13:52

Hi all, I would like to ask if anyone has configured or knows how to have a bulk update in a item list. For example, the idea is to have many lines and select the ones that will move from Project A to Project B and then all of those lines will create a subworkflow to request an approval from per

Hi Martin, Thank you, I've added the config you send but also created a SQL query under the layout for the item list. It worked somehow! Thanks

Hi Martin, I've tried to use the AS but still not working. I've switched for a form rule, working as call back because the field is calculated through a change field action. But it's not working as well. Did you tried with form rule? Thank you!

Hi, Using the else if, it gives an exemption error in the system. I've switched for case when (select case when '{SFD:640}' =0 then '#90EE90' when '{SFD:640}' 0 then '#FFFACD' else '#FF6347' end) But it's giving an error of no column specified for nn. I've switched to objects tab

Hello all, I have an item list where I want to display some column color based on the value that will be the outcome of 2 dates. I would like something like if it's zero, the column should be green, if it's between 0 and 30 days, it should be yellow and if more than 31 days, it should be red.

Hello everyone, Hope you're all doing great! Does anyone by chance knows how to configure an email that only the newest row in an item list form field will be sent in the email? The examples from webcon are how to paste a complete item list in the email but I just want the new one (that I have

Hi Daniel, Coming back to this as I'm having issues with webcon. So, the configuration for one of the cases that I can't solve is: Case 1: - Form Field single text where the user will add the name on the supplier (it can be the complete name or not) - Timeout step where the process will r

Hi Daniel, It looks like it's not possible. Although it would be the correct count for the overdue or at least make a timeout connect with the task creation. I'm writing this in the user voice, maybe they can have an idea! Thank you!

Hi all, I have a process where the user fills in information in a datasource form field. When a value is picked, one of the columns in that datasource is copied into another field (status). This field-status is used in a control step to move the process accordingly. But I need to have that info