I'm not english native but I would help you in whatever you need. Note that I'm just set 9 cases because the data need on the Textinput should have always 9 columns, but you can set the number of columns that you need regardless of the number of rows to submitĬlear(TotalCollection2) ForAll(Split(TextInput3.Text Char(10)) Collect(TotalCollection2 )) This is how my submit button is configured. The text pasted will be converted on the submit button before "patching" the data in your Sharepoint list.Ĥ. Press CTRL+C or right-click->Copy to copy these selected. I paste the data right from Excel there.ģ. Get Amazing Excel Tips and Hacks right in your inbox Select the visible rows that you want to copy. (In an Excel spreadsheet, highlight the values and press Ctrl+C (on PC) or Command+C (on a Mac/iOS) to. My variables are all text, below you can see a big TextInput control with multiple lines. From your data source, copy your list of IDs. This is where the magic (Collection creation) happensĢ.
Yes, this code needs to be on the Submit button. Let me answer your questions in following order:ġ. Just saw your comment I think that this code will definitly works with your case.
0 kommentar(er)
