Forum Discussion

cameroon's avatar
cameroon
Frequent Visitor
2 years ago
Solved

Dynamic Table when calling data from API

I am getting data from an API request which requires me to include a number of parameters that are dynamic.  The first one is the ID of the circuit I wish enquire on.  I have set this up to allow the...
Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    Hi cameroon 

    In this case, the Source step is returning a record with a single field whose name corresponds to fldPhase2ID.

     

    Either of these should work for the Phase to find step:

    1. Return the value of the field whose name corresponds to the value of fldPhase2ID:

    #"Phase to find" = Record.Field( Source, Text.From( fldPhase2ID ) )

    or

    2. Return the value of the first field of the record:

    #"Phase to find" = Record.FieldValues( Source ){0}

     

    I would probably recommend method 1.

    Does this work for you?

     

    Regards

OwenAuger's avatar
OwenAuger
Super User
2 years ago

Hi cameroon 

In this case, the Source step is returning a record with a single field whose name corresponds to fldPhase2ID.

 

Either of these should work for the Phase to find step:

1. Return the value of the field whose name corresponds to the value of fldPhase2ID:

#"Phase to find" = Record.Field( Source, Text.From( fldPhase2ID ) )

or

2. Return the value of the first field of the record:

#"Phase to find" = Record.FieldValues( Source ){0}

 

I would probably recommend method 1.

Does this work for you?

 

Regards

  • cameroon's avatar
    cameroon
    Frequent Visitor
    2 years ago

    Hi OwenAuger 

     

    Never tried option 2 as option 1 worked perfectly.  I understand the logic of it, but know there was no way I was getting there on my own.  Thanks for the help