Skip to main content

Notifications

Community site session details

Community site session details

Session Id : sV15iWVsEifn/172+2S1PX
Power Automate - Process Mining
Unanswered

ms planner to power BI

Like (0) ShareShare
ReportReport
Posted on 3 May 2023 12:52:57 by

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?

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Process Mining

Overall leaderboard
Loading started