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,
Solved! Go to Solution.
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.
Hope the content above may help you.
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 here is excel on one drive, before I add a new task and run:
New task added in Planner
Flow run successful
Excel updated with new task
Flow steps in next comment.
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.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.