• Jerry Mascaro
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I am trying to find out how to use the contents (value) of a cell as an Excel  power query parameter. I have set up a power query to get data from a Salesforce object (table) and that works. I am also able to filter the records returned using a filter value (a constant that identifies one record) and that works. How can I select a single record from the object (table) by referencing the cell contents (a value that is the key value of the one record I wish to return). I have tried defining a named range (name manager) to identify the cell value and an excel table to identify the cell value, but I can't find the exact syntax to get either working in the filter.  I will greatly appreciate whatever responses that I get from the user communirty. thank you.