Forum Discussion
Dynamically Change Excel Worksheet Tab Name in Power Query
My project sends a daily file, which goes through a Power Automate process and saved to my departments SharePoint site. The Excel worksheet name of the file changes based on who sent the email. The f...
Anonymous if that Sheet is the only object in your files then simply remove Item name selection
Sheet1_Sheet = Source{[Kind="Sheet"]}[Data]
Anonymous if that Sheet is the only object in your files then simply remove Item name selection
Sheet1_Sheet = Source{[Kind="Sheet"]}[Data]