"List Rows" Dataverse Action very slow - Getting notes

(0) Share

Report

Posted on by TesterPA

Hi,

When trying to retrieve records from the "Notes" entity, I get results after several minutes.

I know that the problem comes from the documentbody field because in my results I have Jpeg images whose size exceeds 5 MB. I tried to use the http action via Odata but again the request takes a minute. Is there a way to get the answer faster ?

When I try in javascript going through XMLHTTPRequest I get a response in 3 seconds.

Thank you for your help.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

TesterPA 11 on at

Like (1)

Report
Copy link

Link copied!

I discovered what explained the difference in time between the execution of my query in JavaScript and the same query that I executed in Power Automate. This is due to data compression. Web browsers can automatically manage data compression when making HTTP requests. If the request from the server does not use compression this increases the size of the data transferred, which slows down the transfer.

Looking in the settings of my "List Rows" action I saw that there was the possibility of compressing the data and my execution time went to 3 seconds instead of several minutes. I still have to check the possible effects that this could have but for now my problem is solved.

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!

@TesterPA

Thanks for sharing your findings back with the community.

Was this reply helpful? Yes No