Forum Discussion
Create Sharepoint folders based upon power bi table
Hi christinepayton , firstly, thanks for your time & reply.
I'm a no-code person hence starting to be lost when I hear about JSON and so on :), I also saw it was possible to create a folder in a library based on a sharepoint list update from an excel file (the excel file has the same data as my bi report table, I just got the data in an excel sheet with a connection instead of a pbix).
The scenario would be as such :
1) Excel file listing all of the supplier accounts stored in a sharepoint & refreshable (let's say once a week)
2) If new rows, create relevant list entry (I concatenate the supplier code & name to get a unique ID) That is where I guess I'll have to check & compare to existing values wether the unique ID has been found or not, if yes then nothing (already existing entry) if not then create list entry leading to a folder creation in the library.
I'm not looking for the shortest way to achieve this, but rather for the simpliest way for maintenance purposes with the less possible code. Even if that means adding a few steps to the process.
Once again, may thanks for the help & time & I wish you a nice day.
Most Valuable ProfessionalYeah, if your Excel file is in SharePoint then you don't need to query the dataset and do the parse JSON. It was only suggested because you were asking for data in a Power BI table to make the folder in the question title--
You might try asking this in the Power Automate forum if the solution you're looking for doesn't involve Power BI - you'll get a better response there. 🙂
christinepayton thanks for the tip, i just posted my case over there. The Power BI option seems to be the most robust & automated option as the dataset refreshes daily, but the excel option seems more in reach for no-code people :). Thanks for the time you took to reply.