Unanswered

Pulling data from HTTP request in Power Automate Desktop

(0) Share

Report

Posted on by CU01101358-0

I am trying to pull data from Power Automate Desktop from an HTTP Request. It is simple in a cloud flow but very difficult in Desktop.

I converted the HTTP Request to a JSON Custom Object and am still struggling with syntax. The documentation says one thing, but I read on a forum that the syntax was recently changed. Does anyone know how to access the data in a custom object?

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 32,932 Most Valuable Professional on at

Like (1)

Report
Pulling data from HTTP request in Power Automate Desktop

Hi @CU01101358-0,

Can you share a screenshot of the original HTTP response? Does it return an array? If so, you should be able to use an index for this.

Below is an example which returns a Title property value of the first item (nested with the value property of the HTTP response)

=Index(HttpRequestResponse.value, 1).Title

This was the structure of my response.

Was this reply helpful? Yes No
CU01101358-0 61 on at

Like (0)

Report

Pulling data from HTTP request in Power Automate Desktop

Hello @Expiscornovus
My HTTP request returned the same as yours, I will try this out thank you!

Do you happen to know why the language seems different between Cloud Flows and RPA? I understand they do different things but it seems like the underlying language is different for pulling information from requests.

Was this reply helpful? Yes No
Expiscornovus 32,932 Most Valuable Professional on at

Like (0)

Report

Pulling data from HTTP request in Power Automate Desktop

Hi @CU01101358-0,

Desktop flows nowadays use Power Fx (when you enable it on your flow):

https://learn.microsoft.com/en-us/power-automate/desktop-flows/power-fx

Cloud flows use:

https://aka.ms/logicexpressions

Was this reply helpful? Yes No
CU01101358-0 61 on at

Like (0)

Report

Pulling data from HTTP request in Power Automate Desktop

Thank you for clarifying that for me

Was this reply helpful? Yes No