Content of an Excel file in a choice single drop down list
I 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?
Page 1 / 1
Hi @poirisop,
I can’t see a direct way to create a data source from an Excel sheet in Nintex Workflow.
Solutions:
You could create a scheduled workflow that retrieves your Excel sheet and then creates/updates a table in Nintex Workflow. You could run it as often as needed. Using the linked Xtension from the Gallery, you can use the Read Excel file action to read the contents of the Excel file. https://gallery.nintex.com/t/toolkit-for-nwc. Then, create a data source with the Table to use in the form choice control.
Use Google Sheets instead of Excel and create a data source directly to the sheet.
Hi @poirisop
Did Simon's suggestions help you find the answer?
Not 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
Hi @poirisop,
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.
Thanks @SimonMuntz
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.