Forum

When is the Power Automate flow triggered? If the book is not open in Excel Web, there may be no active sheet.

Why not? There is no difference between get data from folder and get data from sharepoint folder, they both provide a list of files in that folder....

Hi Peter, Not seeing the correct code in your sample. Microsoft docs has this first line: function main(workbook: ExcelScript.Workbook): ReportImag...

Not everything can be set from vba unfortunately. You can use the Object Browser to explore the objects properties that can be used in vba (from VB...

You can try getting data from folder as suggested here: If there are differences in columns names, the function provided there will be able to get a...

I'm afraid there are very few people with this need. If you need more than 1 fiscal year, I guess you'll need to run the code for each year separat...

Hi, You have here an example for using selenium: You should be able to get geolocation data from Google Maps API, of Bing Maps API, however they ...

Have you checked the syntax? Does not look to be correct: findelementbyxpath ("//img[contains(@alt, 'air')] The 3 chars in red don't have the pair ...

Hi Toynk, You have to use API query parameters: First, query the API to extract the total count of items with the count parameter. TotalCount=...

Ok, so I assume you have filtered out the files starting with "~" before extracting data from those files? = Table.SelectRows(Source, each not Text...

What errors? I tested again, and the trick still works, I can refresh a query from folder even if files are open.

Keep in mind that in normal pc folder you should see a temporary copy of the file you are opening, starting with "~$" then your file name. You cannot ...

I used this function: (FilePath as text)=> let Source = Excel.Workbook(File.Contents(FilePath), null, true), #"Filtered Rows" = Table.SelectRow...

Hi Tim, Please upload some sample files so I can see your structure variations, will send an example of how it should be done. Yes, the solution al...

Hi Tim, If you have used the automatic file combiner (From Folder), that method is not flexible. See this topic for a flexible alternative: