Unanswered

Unable to process template language expressions in action 'Union_....'

(0) Share

Report

Posted on by Community Power Pla...

I am getting the following error when testing my flow to export a sharepoint list with 7000+ entries, Please, share me your thought, I can't seem to figure out the cause of the error.
"Unable to process template language expressions in action 'Union_result_with_arrItems' inputs at line '1' and column '26092': 'Template language function 'union' expects parameters of same type, but found 'Array,Object' distinct types.'."

Screenshot 2020-12-28 173407.png

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@Anonymous , from the error it looks like you are using Union function the "Union result with arrItems" action, and that union function has parameters of array and object. Union function can accept all array parameters or all object parameters but not both at same time.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@annajhaveri Thank you for replying, I have fixed the union function, but now the flow is running but not completing...any ideas?

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

What is the condition on the do until? When boolEmpty is true? For a query like this why not use pagination on the get items action, then you will not need to have the do until loop.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @Paulie78 ,
I am trying to get more then 7000 entries from sharepoint to excel, and I don't have a premium plan of power automate so I am using do until loop.
I am following this guide to make my flow "Get more than 5000 items from SharePoint with Power Automate (tachytelic.net)"

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report

Ok, I wrote that guide.. I guess boolEmpty is never being set to True. You could try this method instead, easier:
https://www.tachytelic.net/2020/12/power-automate-sharepoint-5000-items-easy/
But the method you are using should also work.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hello @Paulie78
Thank you for sharing this great guide for everyone.
Unfortantely I seem to be doing something wrong in my steps when editing the flow, because I am getting this error
odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The expression \"{\"listName\":\"DailyReport\",\"fields\":\"ID,SN\"}\" is not valid."}}}

I tried creating the flow from scratch and impoting your flow and changing the settings but none of them seem to work. 😓

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report

What step does this happen in?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @Paulie78
The error happens in "EachThread>>QuerySharepoint"

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey @Anonymous @Paulie78 how did you fix the union error above? I am having the exact same problem with Array, Object

Was this reply helpful? Yes No
adedapo 256 on at

Like (0)

Report
Union has a parameter limit of 10 items. I.e. it can't work with more than 10 arrays.
Use this instead
replace(join(your_array_of_arrays,''),'][',',')

Was this reply helpful? Yes No