Hello, I have created a flow which has automated exporting all the plans, tasks and check lists to a excel file. This is set up to run everynight at 11pm.
it works by running a loop that goes through each plan then task then check list. This is then added to a corresponding tables.
The power Bi report pulls from the excel spread sheet it is that I'm having issues occur.
One is the original flow would not clear the excel file so I would get duplicates the next night. Another one is that modified flow just will not function and I get.
InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#length for usage details.'.
For the original error I created an excel script that should get rid of duplicates but it doesn't work very well and was wondering is their another way for this? Also eventually I am planning on changing out the excel tables for sharepoint lists which means the excel scripts will not work.
Please can some one help me?