Forum

Hi Celeste, No Power Query can't do that. VBA can, is VBA a viable solution for you? Regards Phil

Hi Jeroen, In your Excel workbook the logic you are using to determine the type of the meal doesn't make sense. According to the workbook the type...

Hi Ben, Without the actual data I'm guessing as to what your data is. If you had dates in your table, you could do this with time intelligence fun...

Hi Felix, You can download the CSV files from here Power Query Get Files from a Folder Regards Phil

Hi Tom, Do you mean coverage by us? We'll probably look at covering Office Scripts but not sure about Power Automate. The difference is Office Sc...

Hi Tom, This forum isn't for Power Automate, afraid we can't help. Try posting your problem here Microsoft Power Automate Community - Power Plat...

No worries.

=if List.PositionOf( Module [Charge Type],[Charge Type] ) = -1 then "N/A" else List.PositionOf( Module [Charge Type],[Charge Type] )

Hi Mohamed, I can't reproduce your issue. If you have the data as text in Power Query then when you load it to Excel it should still be text. A...

Hi Francisco, Nothing attached. Click on Start Upload after selecting the files/images. Phil

Hi Marcelo, If you want a great overview of Power Pivot start with this Power Query and Power Pivot Definitive Guide Something more advanced Exc...

Hi Robert, Did you mean to attach a file? After selecting the file you have to click on Start Upload. Phil

Hi Gantayya Sorry we don't have any courses on Power Automate and don't offer any support for it. Regards Phil

Hi Nirantar, How is your code accessing the folder where the images are stored? Are you using environment variables from the PC? Is the path ha...

Hi Jaroslav, That code isn't making any query for data. The code you have pasted gets the authorization token from Paypal. You then need to use t...