I have this formula working in the Sandbox on a fieldupdae
DATETIMEVALUE(TEXT(YEAR(PeopleCloud1__Date_First_Interview__c ))+"-" +TEXT(MONTH(PeopleCloud1__Date_First_Interview__c))+"-" +TEXT(DAY(PeopleCloud1__Date_First_Interview__c))+" "+TEXT( Hour1stInterview__c-10 )+":"+ TEXT( Minutes1stInterview__c )+":00")

But in Production I am getting the error
Computed an invalid date, such as February 29th on a non-leap year. Please contact your administrator; formula fields can cause such errors.

I am entering the values from a date field which is saved and therefore has to be valid and 2 numbers one for Hours and one for Minutes which are both valid

As mentioned it works in the sandbox but not in production

Any ideas?

I am trying to make is easier for users to enter the time of an appointment using a formula field - it works in my sandbox and will let my upload and download the changeset into Production but I get the following error when I validate it 

1) "UpdateCandidateManagement (Record Update) - The field "PeopleCloud1__Date_and_Time_First__c" isn't compatible with the Number element "Datetime2". "Datetime2" can't be a Number."

The user enters the date, the hour and minutes in seperate Inputs and the formula combines this into a datetime field which then updates the datetime field on the record.  As I said it works and the Users prefer it but I just can't get it across into production.... 

Any ideas.

Matt

We have been designing a FLOW within a demo org and have hit a brick wall.

We have created a flow using a custom button on an opportunity record that creates a new invoice and drags the amount, account id and some other data into the INV record.

How can I extend its usage by pulling the products into the line items within the invoice using flow? Any idea's?

I started by using an opportunity line item lookup to gather the data and assgined to variables. The problem I face is getting that data to show on the INV record of the specific opportunity.

I have this formula working in the Sandbox on a fieldupdae
DATETIMEVALUE(TEXT(YEAR(PeopleCloud1__Date_First_Interview__c ))+"-" +TEXT(MONTH(PeopleCloud1__Date_First_Interview__c))+"-" +TEXT(DAY(PeopleCloud1__Date_First_Interview__c))+" "+TEXT( Hour1stInterview__c-10 )+":"+ TEXT( Minutes1stInterview__c )+":00")

But in Production I am getting the error
Computed an invalid date, such as February 29th on a non-leap year. Please contact your administrator; formula fields can cause such errors.

I am entering the values from a date field which is saved and therefore has to be valid and 2 numbers one for Hours and one for Minutes which are both valid

As mentioned it works in the sandbox but not in production

Any ideas?

I am trying to make is easier for users to enter the time of an appointment using a formula field - it works in my sandbox and will let my upload and download the changeset into Production but I get the following error when I validate it 

1) "UpdateCandidateManagement (Record Update) - The field "PeopleCloud1__Date_and_Time_First__c" isn't compatible with the Number element "Datetime2". "Datetime2" can't be a Number."

The user enters the date, the hour and minutes in seperate Inputs and the formula combines this into a datetime field which then updates the datetime field on the record.  As I said it works and the Users prefer it but I just can't get it across into production.... 

Any ideas.

Matt

I have a collection in a visualworkflow that is failing on the first decision element within the flow. I'm getting the following error:

FLOW_ELEMENT_ERROR|The flow failed to access the value for Item.Product_Family_Getter__c because it hasn't been set or assigned.

However, I am definitely setting the field and can see that the flow has it at an earlier point in the debug log:

Building the collection of Opportunity Line Items:

17:27:27.411 (411151510)|FLOW_VALUE_ASSIGNMENT|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|getDealItems|true
17:27:27.411 (411228209)|FLOW_VALUE_ASSIGNMENT|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|OpportunityLineItems|[{Name=Crest-ONE Comm- White Teeth ONE Connect, CurrencyIsoCode=USD, Id=00kg0000004G4MeAAK, License__c=Subscription, Product_Family_Getter__c=ONE Connect}]
17:27:27.411 (411251830)|FLOW_BULK_ELEMENT_DETAIL|FlowRecordLookup|getDealItems|1

Iterating through the collection
It can be seen that the Item definitely has the field "Product_Family_Getter__c" assigned

17:27:27.411 (411944263)|FLOW_ELEMENT_BEGIN|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|FlowLoop|Loop_through_Line_Items
17:27:27.412 (412846666)|FLOW_VALUE_ASSIGNMENT|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|Item|{Name=Crest-ONE Comm- White Teeth ONE Connect, CurrencyIsoCode=USD, Id=00kg0000004G4MeAAK, License__c=Subscription, Product_Family_Getter__c=ONE Connect}
17:27:27.412 (412858987)|FLOW_VALUE_ASSIGNMENT|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|Loop_through_Line_Items.currentIteration|0

However, I still get this error:

17:27:27.413 (413041600)|FLOW_ELEMENT_BEGIN|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|FlowDecision|Is_this_a_NOW_Item
17:27:27.414 (414510540)|FLOW_ELEMENT_END|9831cff0c4b4f94bdd20336c790e146f2a7e2ab-19d3|FlowDecision|Is_this_a_NOW_Item
17:27:27.421 (421733197)|FLOW_ELEMENT_ERROR|The flow failed to access the value for Item.Product_Family_Getter__c because it hasn't been set or assigned.||

What else should I be doing? I attach a quick picture of the section of the flow that's failing:

Hi,
I am using a flow to allow a user to edit a record.
I can display the current value of all the fields in the record except for picklists - is there any way to do this?

Also all my picklists in the flow are mandatory - do they have to be?

I have a flow where I have a dynamic choice to display contacts associated with an Account. I am trying to do a record update, but have a couple of questions on functionality:

1. Is it possible to pre-populate input fields with the existing information from the dynamic choice? ie. display the First Name, Last Name, Title, etc if they are already filled out in the contact record.

2. I setup up the record update and mapped the fields to the contact record, but it updates them all, whether they are blank or not. So if I just wanted change the first name, it updates the first name, but updates the rest of the fields to blank.