Best way to populate a list box using a file picker

Aaron Scott

April 10, 2023 20:52

I would like to create a workflow that allows the user to pick an excel file or CSV and have the WF use a field to populate a list box. I am very new to WF and am having a hard time getting started. I assume I should use Get Text from File, but I do not know how to get the text from the file to the list box.

0

• 

  Berend Veldkamp

  April 18, 2023 12:19

  I think you need these four activities (haven't tried myself yet):

  1. Run Operation with results.from-csv or results.from-xlsx
  2. Run Operation with results.to-graphics
  3. Get Form Element Items From Features
  4. Set Form Element Items

  1
• 

  Ken Lyon

  April 18, 2023 15:27

  If you have Workflow installed on-premises, the following activities could be used in a Server Workflow:

  • Convert CSV To Data Table
  • Convert XLSX To Data Set

  The server workflow could use the Set Workflow Output activity to return the data.

  You would also have a Client Workflow which shows the form with the file picker, sends the file as an input to the Server Workflow and then passes the output to the Get Form Element Items From Collection activity. Finally, the client workflow would use the Set Form Element Items activity to populate the list box.

  1

Please sign in to leave a comment.