How to use the timestamp and output of one query as parameters for another query?

[UsePowerBI]

Hello

I have a query which resolves to a single piece of text.

I want to:

1) use that piece of text as a parameter in the code of another second query without having to run the first query again

2) use the timestamp of when I run the first query as a parameter in the second query without having to run the first query again of course

3) if a specific amount of time has passed since running the first query, I want to rerun the first query again when I attempt to run the second query 

Any idea how to achieve these?

Thanks!

[lbendlin]

That sounds like something you want to do in Power Automate, not in Power Query.

your 2) requires that you record that timestamp and return it together with the text.

your 3) is far outside of the design envelope of Power Query, even considering Function.InvokeAfter()