Forum Discussion

adam_mac's avatar
adam_mac
Icon for Helper I rankHelper I
5 years ago
Solved

Data source settings - Load file using wildcard match

hi, a pretty common problem im sure but i havent been able to find a solution. I load a file into my dashboard every week from the same folder (deleting and replacing the previous weeks file). The fi...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    At least two ways to solve this one

    1. Use a Power Automate flow to move the file (from email?) to the final location (SharePoint/OneDrive?) renaming it as part of that

    2. Use the SharePoint or Folder connectors so you see all the filenames, then filter on the filename column for Contains "ExampleFile".

     

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

At least two ways to solve this one

1. Use a Power Automate flow to move the file (from email?) to the final location (SharePoint/OneDrive?) renaming it as part of that

2. Use the SharePoint or Folder connectors so you see all the filenames, then filter on the filename column for Contains "ExampleFile".

 

Pat