Forum Discussion

Bommy's avatar
Bommy
Frequent Visitor
3 years ago
Solved

How to Account for a new File Path daily

Hello There!   Currently I am stuck on a problem with my data source and couldn't find much on this type of issue without utilizng something like power automate. I am just currently a "small fry" i...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    You can have a cell in Excel into which the user places the variable, then use Get Data "From Table". Name that Query "DateVar". Then in your path, replace your "13AUG2023" with &DateVar&

     

    Now your user can add the variable in the cell and hit Refresh All.

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
3 years ago

You can have a cell in Excel into which the user places the variable, then use Get Data "From Table". Name that Query "DateVar". Then in your path, replace your "13AUG2023" with &DateVar&

 

Now your user can add the variable in the cell and hit Refresh All.

 

--Nate