Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 18, 2025
Topics: 61 / Replies: 1579
Reply
RE: Calculated cells outside the Pivot Table

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

1 year ago
Forum
Reply
RE: Videos Power Pivot

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...

1 year ago
Forum
Reply
RE: What Is The Smartest Way To Combine/Update tables while blocking duplicates ?

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

1 year ago
Forum
Reply
RE: Automatic sending of emails with red colored rows

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

1 year ago
Reply
RE: Images not inserted - BN.Net

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...

1 year ago
Forum
Reply
RE: Paypal transaction list via PQ API call

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...

1 year ago
Forum
Reply
RE: power query error on one computer but not other

Hi James, I'm not sure how the data refreshes as that page doesn't exist. Please supply your file, it's impossible to check anything otherwise. ...

2 years ago
Forum
Reply
RE: Power Query Paginating from Dataverse API Help

Hi Matthew, I don't get any errors with this code, I'd need your file to see how it is being executed against the data you are receiving. Typica...

2 years ago
Forum
Reply
RE: Data Model - Measures, functions showing multiple times

Hi Elle, I'm not following the problem. Can you supply some screen shots and maybe the file(s) You've posted in the Power Query forum but measu...

2 years ago
Forum
Reply
RE: In Microsoft Power Automate, is there a way to look at a previous version of a Flow?

Hi William, This is a Power Query forum, not Power Automate, sorry we can't help with this. Regards Phil

2 years ago
Forum
Reply
RE: What is the proper way to use the ' ' return character in a Power Automate Flow?

Hi William, This is a Power Query forum, not Power Automate, sorry we can't help with this. Regards Phil

2 years ago
Forum
Reply
RE: reporting in Excel

Hi Sam, If you found the response unhelpful I'd say that's because the initial question was vague. If you wanted to know if there is a forms build...

2 years ago
Topic
Replies: 1
Views: 183
Reply
RE: TextJoin by ID

Hi Dominic, No file attached. After selecting the file, click the Start Upload button and wait for it to upload fully. Phil

2 years ago
Reply
RE: FINDING MONTH

Hi, You haven't said what version of Excel you have. If you can use XLOOKUP try this =XLOOKUP(MAX(B2:K2),B2:K2,$B$1:$K$1) or with INDEX MATC...

2 years ago
Page 5 / 110