Answered

Flow works but runs slowly - wondering if it could be better

(0) Share

Report

Posted on by theappwhisperer

Hello! 😄

I have a flow that runs a query on a PowerBI dataset, parses the results and then either (a) updates an item in my Sharepoint list if it's already existing or (b) makes a new Sharepoint item.

The flow determines if it's new or existing by filtering for items that have the same 'Title' (plain text field) AND the same 'Name Only' (plain text field).

It works but it's slow, around 30 min for 500 items. I'm wondering if this is an acceptable time for this to take or if I should be doing something different in my flow to make it faster?

Pictures attached.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @theappwhisperer

To optimize, you could use 'Get items' action without filter query before loop (For each 1) and within loop you could use filter array to check for the existence of item in SharePoint list. This would avoid network call (get items) for every item as we have already had already those as output of get items action.

You could try & check if that optimize the execution time of the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
theappwhisperer 14 on at

Like (0)

Report
Copy link

Link copied!

Hey, I've tried to use your suggestion but keep getting an error message. I seem to be able to do a single condition but when I try to add the 'and' component, it won't work. Do you know what I'm doing wrong? Pic attached.

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @theappwhisperer

You need to refer column value using item function in query. Here is an example of complex filter query, pls modify it as per the need:

@and(equals(item()?['Title'],'<dynamic value>'),equals(item()?['<column internal name>'],'<dynamic value>'))

Basically, item takes internal name of the column in SharePoint list. You need to pass the dynamic value from previous action for comparing with SharePoint column values.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No