How to populate form fields with calculated values

[MikeCrawford]

This should be dead easy, and likely solved 1000 times before, but I'm trying to get various user profile attributes to populate various form fields. I am able to put calculated fields on the form, and those work great, but how do I put the calculated values into the form fields? I have tried naming the calculated fields, but can't set the form fields. I've tried connecting the calculated fields to the form fields, but that doesn't work either. This seems like it should be exceedingly simple. What am I missing?

[SimonMuntz]

Hi,

Based on your screen shots you have your controls on the left bound to the SharePoint columns and you have a calculated control also bound to the same column. This means the calculated column control will populate the column and the columns on the left will clear the columns.

[MikeCrawford]

But the columns on the left are not populating. How do I get them to populate?

[SimonMuntz]

If you are getting the same information in a calculated value why do you need both sides to populate?

[MikeCrawford]

The fields will be sent via an email notification (workflow) to an external entity. I need to have the values recorded in the list so the workflow will work (and presumably flow!)

[SimonMuntz]

I get that but you dont need to have the information in the controls on the left and the calculated controls especially if both sides are connected to list columns.

[MikeCrawford]

I'd love to remove the calculated fields, but how do I get the values to populate in the list fields?

[SimonMuntz]

Put the same formula in the default field of the left hand controls configuration and then remove the calculated value controls.

[MikeCrawford]

I tried that initially but it puts some horrendous guid in the field.

[MikeCrawford]

I'll keep experimenting and will pull screenshots if I can't get it. Thanks so much for your help, @SimonMuntz