Unanswered

an HTTP request to SharePoint (POST method)

(0) Share

Report

Posted on by jackpol

Hi all

In sharepoint I have grouped elements and I would like to receive the sum of points of these groups. To calculate the sums of individual groups of elements I use the "an HTTP request to SharePoint" (POST method). Flow worked fine until a certain point when an error started popping up: .

1.First photo

InvalidTemplate. Unable to process template language expressions in action 'Agregaty' inputs at line '0' and column '0': 'The template language expression 'body('Send_an_HTTP_request_to_SharePoint')['body']['Row']' cannot be evaluated because property 'body' doesn't exist, available properties are 'Row, FirstRow, FolderPermissions, LastRow, RowLimit, FilterLink, ForceNoHierarchy, HierarchyHasIndention, CurrentFolderSpItemUrl'.

However, when I look at the flow as it went in action, an HTTP request to SharePoint body is visible

2.Second photo

I don't know how to fix it because I didn't change anything in the flow that worked and the flows that failed.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

SamLed 2,338 Moderator on at

Like (1)

Report

Hi,

Give a try with following expressions: body(''Send_an_HTTP_request_to_Sharepoint)['Row'].
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
jackpol 5 on at

Like (1)

Report

It worked but had another problem

The execution of template action 'Agregaty' failed: The evaluation of 'query' action 'where' expression '{
"Nazwa jednostki": "@item()?['JednostkaOrganizcyjna']",
"Suma kilometrow": "@item()?['SumaDystans.SUM.agg']",
"Suma punktow": "@float(item()?['Punkty.SUM.agg'])"
}' failed: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

I would like to sort from the highest value of points for each group to the smallest. Do you know how I can do it? The problem here is the space, because between "1,000" it reads as a different type by a space

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

Hi There,

This is because of the comma in "1,000" causing a type mismatch. Use 'replace' like this
'@float(replace(item()?['Punkty.SUM.agg'], ',', ''))' .

Once you have corrected the type error, you can sort the results based on the 'Punkty.SUM.agg' values.

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
jackpol 5 on at

Like (1)

Report

The execution of template action 'Agregaty' failed: The evaluation of 'query' action 'where' expression '{ "Nazwa jednostki": "@item()?['JednostkaOrganizcyjna']", "Suma kilometrow": "@item()?['SumaDystans.SUM.agg']", "Suma punktow": "@float(replace(item()?['Punkty.SUM.agg'], ' ', ''))" }' failed: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

I changed space with float(replace(item()?['Punkty.SUM.agg'], ' ', '')). Still not working 😞

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

Hi There,

To fix the issue, you should ensure the string format is convertible to a float. Use the 'replace' function to also replace any commas , with a dot . to ensure the correct decimal format. Ensure the data does not contain any non-numeric characters after the 'replace' functions have been applied.

For example -
"Suma punktow": "@float(replace(replace(item()?['Punkty.SUM.agg'], ' ', ''), ',', '.'))"

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No