Forum Discussion

msellner_1025's avatar
msellner_1025
Icon for Helper I rankHelper I
3 years ago
Solved

Use Result of Query 1 in Query 2

Hello!     I have a query that returns a random file name that I need in order to download a csv formatted reported. Below is the power query that I have set up – it returns the file name as expect...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi msellner_1025,

     

    According to the format of what you say works the line should look like:

     ""fileName"":""" & Expensify_PullDataRequest & """

    Otherwise you either missing the "" ( ""fileName"":Expensify_PullDataRequest) or send Expensify_PullDataRequest as value instead of  is_reconciliation_2816079167651847981.csv.

     

    Cheers,

    John

jbwtp's avatar
jbwtp
Icon for Memorable Member rankMemorable Member
3 years ago

Hi msellner_1025,

 

According to the format of what you say works the line should look like:

 ""fileName"":""" & Expensify_PullDataRequest & """

Otherwise you either missing the "" ( ""fileName"":Expensify_PullDataRequest) or send Expensify_PullDataRequest as value instead of  is_reconciliation_2816079167651847981.csv.

 

Cheers,

John

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

 

msellner_1025 I think jbwtp has it correct here: you'd need to send the quotations as part of the command, something like this:

"" & Expensify_PullDataRequest & ""

 

Pete