how to send values of two seperate repeating table into one textfield via workflow? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

how to send values of two seperate repeating table into one textfield via workflow?

Last post 08-19-2017 09:24 PM by azadeh. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-18-2017 10:26 AM

    • azadeh
    • Not Ranked
    • Joined on 08-15-2017
    • Posts 6

    how to send values of two seperate repeating table into one textfield via workflow?

    I want to store values of two repeating tables into one text box in SharePoint form library.I have two repeating tables with text fields. I concatenated the values of each row of each repeating table into one text box field using the formula: concat("-", field2)and I promoted this concat field of repeating field select "merge", then I created a separate text field in the form and enabled the multiline option, and trying to set it to store all the values from the text boxes of this two repeating tables via workflow .I mean suppose the concatenated field of repeating table 1 is "X" and for the second repeating table is "y" and the destination text field is "T" then I use action "set field value" in workflow to set field T. the action is: set field T to ....(that I choose ... and select X then enter and select Y ) like this: X(in one line) Y(in the other line) It works fine until two days ago the workflow was canceled. one form was submitted fine but another form did not. I reduce the value which user inserted for X and it works but when I try to submit the first form again to show it works, the first one that was once submitted successfully also canceled and when I reduced the two rows of the first repeating table (value X) workflow runs. I wonder why this happens and I don't know how many characters it supports because when using multiline, the limitation of characters is disabled. Can anybody help me fix this?
  • 08-19-2017 09:24 PM In reply to

    • azadeh
    • Not Ranked
    • Joined on 08-15-2017
    • Posts 6

    Re: how to send values of two seperate repeating table into one textfield via workflow?

    Hi everybody, I fortunately found a way to solve this problem and I think it's good to write it here for others. for solving this issue, I decide to change the properties of field in form library after promotion ,I mean the properties of textbox (destination field) must be changed not in the form only It means you must set the field multiline in form and promote the the field then go to the form library in share point site and in document settings choose the promoted field and change the field from single line of text to multiple line of text and set the lines or choose unlimited line. I hope this is helpful.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.