Is this just part of the building process? Or If I have one query A that loads across the network and 5 follow up queries that refer to query A will power query / excel be reading the across the network 1 time or five times? What is the proper way in Power Query to refer to an existing query and reduce data pulls across the network?
You are confusing Power Automate with Power Automate Desktop. The link you provide is for Power Automate, so those functions won't work in the PADesktop. There is an action named Convert datetime to text in PAD, you can specify the formats you would like there The action lets you pick from existing formats or you can specify one. copy this code to PAD to see a custom example Text ...