cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cairo23
Regular Visitor

How to update excel using planner tasks

Hello everyone, I followed Miguel_E's video: https://www.youtube.com/watch?v=quJl0wCvNkM&t=17s&ab_channel=TecProSvc

and I can't get this flow to update.

 

My flow runs but it refuses to update and never passes into the second condition of add a row.

 

Any help would be amazingly appreciated,

 

Cairo

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Memorable Member
Memorable Member

@cairo23 details :

 

jinivthakkar_5-1614441817266.png

jinivthakkar_6-1614441882974.png

 

jinivthakkar_7-1614441950624.png

 

Apply to each 2 

jinivthakkar_8-1614442011168.png

jinivthakkar_9-1614442041981.png

 

View solution in original post

9 REPLIES 9
v-duann-msft
Microsoft
Microsoft

Hi @cairo23 

 

Thank you for posting.

 

According to your description, you encountered issue while creating flow to update excel based on tasks following up the video.

 

Could you please share me the error message?

 

During my test, I realize we need to change ''Task ID' to 'TaskID' in excel file, otherwise, we can't filter query using TaskID eq '' in 'List rows present into a table' action.

v-duann-msft_0-1614406311798.png

 

v-duann-msft_1-1614406425642.png

 

Hope the content above may help you.

 

Thanks

Anna

cairo23
Regular Visitor

Hey Anna, so I did that but can you get the full flow to work and then send me the solution? I have tried for hours to get mine to work and it doesn't update anything

cairo23
Regular Visitor

cairo23
Regular Visitor

Or if I could get the source flow from any other microsoft employee that would be awesome

cairo23
Regular Visitor

Can I get help from a top user? @tom_riha , @Paulie78 , @annajhaveri @Pstork1 @Expiscornovus 

v-duann-msft
Microsoft
Microsoft

Hi @cairo23 

 

Thank you for quick update.

 

If you need an emergency support, you can go to below website to request a remote troubleshooting support.

https://flow.microsoft.com/en-us/support/

 

Best regards,

Anna

jinivthakkar
Memorable Member
Memorable Member

@cairo23 here is excel on one drive, before I add a new task and run:

 

jinivthakkar_0-1614440813848.png

New task added in Planner

jinivthakkar_1-1614440895822.png

Flow run successful

jinivthakkar_2-1614441002253.png

Excel updated with new task

jinivthakkar_3-1614441594510.png

 

jinivthakkar_4-1614441708420.png

 

Flow steps in next comment.

 

 

 

 

 

jinivthakkar
Memorable Member
Memorable Member

@cairo23 details :

 

jinivthakkar_5-1614441817266.png

jinivthakkar_6-1614441882974.png

 

jinivthakkar_7-1614441950624.png

 

Apply to each 2 

jinivthakkar_8-1614442011168.png

jinivthakkar_9-1614442041981.png

 

View solution in original post

jinivthakkar
Memorable Member
Memorable Member

Logic as explained:

 

- Get all tasks

- Initialize variable used to set bucket name

- Apply to each to iterate through each task - outputs('Lists_tasks')?['body/value']

- List rows in a table - query the excel with first task ID 

If length is 0 it means no task found and add a row in excel else update the row(updating is simple) 

 

formulae to check length -  length(outputs('List_rows_present_in_a_table')?['body']?['value'])

 

Now explaining only adding of new tasks in excel:

if length is 0, now we need to add a task but before that we need to get the bucket name, so 

- list buckets

- apply to each to iterate through bucked id and check if it matches bucket id of the task(each task has a bucket id)

- if it matches then set variable value with bucket name 

- then create a new row in excel which is again simple.

 

Hope this helps.

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (12,148)