I managed to connect the Atomsvc file to my spreadsheet, I would like to run Power Automate Desktop to edit the atomsvc file and then just refresh the spreadsheet. I tried VBA and it got too complicated so I'm not trying Power Automate Desktop to take on this task. I don't have a lot of experience with coding, so please bare with me. I kind of understand the XML language that I know I have to edit in order to change the file. When trying to use any of the actions that are under "XML", I don't seem to be able to get anything besides being able to Read the file.
My first question is " Is Power Automate Desktop the best option to adjust and edit the file so I can adjust the information that the atomsvc?" I'm thinking that maybe even if this file has been written as an XML, I might not be able to edit it as one or it operates differently?
Now if XML is the best option or at least a decent option for me to edit my atom file, why am I getting this error?
My goal is to edit/adjust the date range that follows after "Start Date" & "End Date", and if possible also the title of the file so I can create or change the report, it might need to change also the http too.
I hope I have provided enough information and that my question made sense.