Re: Dependent "calculated value" field to refer to filtered lookup column but showing up as a numerical ID

Reema Daga — Sun, 15 Mar 2015 08:49:55 GMT

Hello,

Thank you for your post on infopathdev.com!

I am attaching a sample form with solution to your problem. Please let me know if this resolves your problem.

Kind Regards,

Reema Daga

Support and Quality Assurance Engineer

Qdabra® Software / 877.544.2389 main / 425 999 4597 direct

NewCalculatedValuesRelated.xsn

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Dependent "calculated value" field to refer to filtered lookup column but showing up as a numerical ID

mockions — Wed, 04 Mar 2015 23:04:04 GMT

I am creating a Sharepoint list that can be populated by an Infopath form. That said, the Infopath form is connected to several Sharepoint lists that will pre-populate the dropdowns/calculated fields/textboxes/listboxes. Currently, I am trying to get a calculated field to populate based on a dropdown selection. Say that the dropdown contains values from a column called "ABC" from a Sharepoint list called "List 1." Also in "List 1" is a lookup column based on a list called "List 2" in a column called "DEF." For my calculated field, I want to be able to get values from "DEF" based on my selection from the dropdown. So, if I select "Apples" in the dropdown menu, the calculated field of "red" will appear, as "apples" (of column ABC) and "red" (of column DEF) are in the same row. What I've done so far is select "DEF" from the List 1 data connection, filter the data to "ID" from the List 1 data connection "is equal to "ABC" from the Main field. However, the calculated field of "DEF" shows up as DEF's respective ID number instead. I would like it to show the text instead. Please let me know if there is anything I could do remedy this issue!

SharePoint Integration

Re: Dependent "calculated value" field to refer to filtered lookup column but showing up as a numerical ID

Dependent "calculated value" field to refer to filtered lookup column but showing up as a numerical ID