Skip to main content
Solved

User parameter - how to feed data

  • March 23, 2026
  • 3 replies
  • 64 views
dataman
Contributor
Forum|alt.badge.img+6

Hello everybody,

I am trying to build a flow app: 

  • The user has an Excel file with 3 columns. 
  • the flow app must show the values of theses columns as one parameter (I want to have the chance to filter the list using one of the 3 columns). 

My Problem is to get the contents of the excel file. If I try it with the User Paramters Window, I can import from dataset or reader formats. But with these options I do not get the contents but the headers or the name of the readers.

I can save the contents of the File in a SQL Database. But I do not know how I can read them and show them in the user parameter List.

 

Has anyone any Idea, how I can get a List with a filter to show those values of the excel?

Thanks in advance!

Manuel

Best answer by arnovananrooij

Hi,

Not really sure if I understand what you're trying to do. Maybe you need the possibility of dynamic parameters. Have a look at: https://support.safe.com/hc/en-us/articles/40509829569805-Dynamic-Parameter-Configurations-in-FME-Flow-Apps.

Arno

    3 replies

    dataman
    Contributor
    Forum|alt.badge.img+6
    • datamanContributor
    • Author
    • Contributor
    • March 26, 2026

    I had some progress:

    I can link the values of the excel reader to the parameter (Setting to a Published Parameter) and the values will be appear list. But if the user updates the table, those changes will not be appear in the list. 

     

    Any idea, how I can “update” the list?

    thanks in advance!

    arnovananrooij
    Contributor
    Forum|alt.badge.img+5
    • arnovananrooijContributor
    • Contributor
    • Best Answer
    • March 27, 2026

    Hi,

    Not really sure if I understand what you're trying to do. Maybe you need the possibility of dynamic parameters. Have a look at: https://support.safe.com/hc/en-us/articles/40509829569805-Dynamic-Parameter-Configurations-in-FME-Flow-Apps.

    Arno

    dataman
    Contributor
    Forum|alt.badge.img+6
    • datamanContributor
    • Author
    • Contributor
    • March 30, 2026

    Thanks Arno.

    Yes, I need that. I am waiting for an Upgrade of our FME Flow. I hope I can do that after it :-)

    Community Stats

    32,456
    Posts
    123,318
    Replies
    40,610
    Members
    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.