Hi, I am new to Power Automate and I am trying to automate the creation of a SharePoint List from an Excel file that is generated by a system. The issue I am facing is that each year the excel YearMonth columns change. I found an example flow online to generate the list from Excel however this flow uses Parse json which requires you to provide the schema so this will not work for me.
Is there any other way I can get around this or a way to automatically generate the schema?
Hi @freddy65 ,
Data structures cannot be defined as dynamic values but you could directly call a field using dynamic values. I've made a test for your reference:
Result
Best Regards,
Bof
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492