
Hi I can create a power query in Excel and it works just fine.
But when I create the same thing in Power Apps it fails at the combine files step.
I'm trying to combine data from multiple Excel ".xlxm" files in a SharePoint library.
Power apps version says "We didn't recognize the format of your first file. ..."
When I tried to copy in the code directly in the advanced editor I believe it's missing a transform file that I'm not sure how to create since it was created in the excel version automatically.