-
You can use multi-line in combination with Read Only and Expand to show all text. Can you try that?
-
Ok, so if the DS name was changed maybe that's not the issue.
Can you try this?: CopyTable /dsnamesrc=ACTWorkHistoryRetrieve /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=d:SharePointListItem_RW
(no leading slash in /rowsrc)
Any changes in the error message?
-
I don't see a data source named "ACTWorkHistoryRetrieve" in your form. I do see the xpath /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW so that portion of the command looks ok.
After that you might run into an issue making sure that the fields match. See the attached screenshot; you might need to reorganize some fields.
-
Scenario: You want to map DATE from InfoPath to SQL DATE data type
Issue: DAT only has a “DateTime” DB Type in the dropdown.
Click DOWNLOAD above to obtain workaround steps for this issue.
-
Because your source is coming from a secondary data source, you'll need an additional parameter: dsnamesrc. Can you modify your command and try it again?
Also, when working with qRules we suggest you display the error, result and success nodes somewhere (for example, a view called Debug) so that you can see the errors and messages returned ...
-
Can you use CopyTable to move the data from the 2ds to the main DOM and then have the mapping submit from the main DOM to the SharePoint list?
-
Are you able to open the form in design mode? Do so and check the Security settings under Form Options. Change the settings, save the xsn and try again. Something must have been added to the form (perhaps code?) to make the template require full trust, but that's just a guess.
-
I'm not sure if it will work, but try setting the link to file:// instead of http://
You can use a rule to set the value of the link field:
value = concat("file", substring-after(., "http"))
-
Attached. I added one rule to the dropdown and tested to make sure it works. Please review the rule and let us know if you have any questions. Thanks.
-
That's the default behavior for repeating tables: it adds a blank, new row. You could use default values or rules to populate the fields in that new row. It'll take some playing around with the rules, but it should be possible. Good luck!