Forum Discussion
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 user to select the relevant ID so that the GET statement is updated accordingly (fldPhase2ID)
The API request changes as expected and returns the required data. I am not sure the correct terminology in terms of how the data is returned but see below
The 23860 is the ID as selected by the user, so can obviously change so I am trying to make
#"Phase to find" = Source[23860]dynamic. I have tried the following with no luck - error message "Invalid Identifier"
#"Phase to find" = Source[Text.From(fldPhase2ID)]I have also tried withoug the Text.From function and get the following error
BI is not my strength, so I am sure what I am trying to do is simple, but I'm certainly out of my depth. Any help appreciated
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
2 Replies
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
