Hi ​@poirisop,

I can’t see a direct way to create a data source from an Excel sheet in Nintex Workflow.

Solutions:

1. 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.
2. 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.

It is working now!

Thank you very much