Infopath- trying to saving two columns data into single col

Netaji Junghari

Hi ,

I have infopath form in which there are 5 columns and i trying for which 5 columns are store in single column woyld be display in SP list.

i have createda calculated control variable , which is not visible in form. on Calculated Control i have applied rule Action->Set a field's Value->(under field selected That variable only)->value: concat(col1,col2,col3,col4,col5)

In infopath i click on file -> Form option-> Property Pramotion-> Add->selected the variable-> Rename it->Saved

There is no error in formaule but please let me know where i did wrong. and which column name under all 5 columns values will be display?

Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Md Tahmidul Abedin7y ago
Accepted answer
Hi,
Here the best case scenario is, the Column is not created in the list.
Please confirm if the caluculated column is showing from the List Settings.

Other wise create a colum maybe as Multiple Text type with Plain Text option.
And Set the logic to store the data in that column. No calculated column needed.

Otherwise, if your five(5) columns has been created in the list and the data are saving those column
as accordingly.You can createa a calculating column and set the rule on that column which you have
set in the infopath.

Hope it will help.
Abhijeet Jadhav7y ago
Hi Netaji,
Instead of concatenating the fields in InfoPath and promoting that column, ideal design would be to create a calculated column in SharePoint and display the concatenation of col1 to col5.