Flow is sometimes slow

[sandra1]

Hello,

I have created a "when a record is selected in the Common Data Service" flow. 

It lists records (currently 8 records) of the entity A. It then searches for the related record of a linked entity B for each record.

It then checks whether a field of record B is set to a certain value and appends the identifier of entity B to either list A or list B, depending on the value. 

The problem is that (as you can see in the pictures below) the whole process sometimes takes over 10 minutes and sometimes 12 seconds. The records are always the same. 

If it takes long it shows a RequestTimeout for some requests of enitity B.

Is there something wrong with my flow or is this a common power automate problem? 

[v-bacao-msft]

Hi @sandra1 ,

After the flow is completely executed, please check which action takes longer to execute.

In addition, please try to set Apply to each to increase execution speed.

Best Regards,

[sandra1]

Hi @v-bacao-msft, 

I tried to parallelize the apply to each, but it didn't change a thing. 

The action that took so long (get a RequestTimeout) is the get record action.  

Each run (that took so long) it is another record that gets a Request Timeout and after a retry, it is successful so I don't think it has something to do with the data.

Do you have any idea how to solve the issue? Is this a flow problem or a common data service problem?