+3I would like to use an Excel file containing a list of products in a data lookup control to select the part.
I know how to do it from an Microsoft List.
To avoid having to manually convert my Excel file into a Microsoft list, can I do it directly from an Excel file that is in my SharePoint online?
or
Can I automate the upload of the content of the Excel file into a microsoft list or into a table?
Best answer by SimonMuntz
Hi
Sorry to hear you are having issues with this solution.
Let me try to help.
In my example I am attaching an Excel file to my start event form.
My Excel:
The first action gets the file from the Start form upload control collection and puts it into a File variable.
Read the Excel file and put the contents into a collection variable.
Loop Through the collection and Query the JSON.
Do the same for Model.
I have logged the text, but you can do what you need to with the data.
Example: Mazda CX5
Workflow Example.
+22Hi
I can’t see a direct way to create a data source from an Excel sheet in Nintex Workflow.
Solutions:
+21Hi
Did Simon's suggestions help you find the answer?
+3Not exactly.
I cannot use Google Sheets. So I decide to try solution #1 with Toolkit-for-nwc.
I am able to read my Excel file and put the result into a text variable. The variable contains the entire content of my Excel file. I thought I would be able to loop through the Excel file and work with one record at a time, OR have the result in a collection variable so I could use collection controls. I really don’t know what to do next with that variable ☹️
+22Hi
Sorry to hear you are having issues with this solution.
Let me try to help.
In my example I am attaching an Excel file to my start event form.
My Excel:
The first action gets the file from the Start form upload control collection and puts it into a File variable.
Read the Excel file and put the contents into a collection variable.
Loop Through the collection and Query the JSON.
Do the same for Model.
I have logged the text, but you can do what you need to with the data.
Example: Mazda CX5
Workflow Example.
+3Thanks
The difference that I have, it is that my Excel file is in my SharePoint Online site. So, my start event is SharePoint - New or update list item. After that, I have a Get a file action. Result to a file type variable (var_file).
In the Read Excel action, I changed the Result variable from a type file to a type collection.
It is working now!
Thank you very much
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
