Hello,
I need some help with a problem that I didn’t met before.
I have this scenario:
I need to bulk import an excel file into a table Budget (in model driven app) like:
I want to create a flow that can transpose ONLY the headers with Something1 etc. into a table called Product Category, with the column called Category like:
When I am doing the import I have the possibility to add a new column in Budget table like "Something5". I need to check in Product Category if there is "Something5" and if is not, to add it there.
Example:
My idea is to check, every time when an import is on process if there is a modification in the number of columns like: Column 1 will be always Location and the last 2 will be always Month and Year so I will COUNT only from 1 to -2 (from all the columns)
I need all steps please, I am new to power automate and already scared of it.
