Is this the correct way to get the first element in an array from parseJSON?

(0) Share

Report

Posted on by pmwhelan

375

I am pulling information from O365 and inserting it into a SharePoint Online list.

It works fine.

I now wish to check is users have "Unlicensed" in their "Licenses" property.

I have a parseJSON step which works for strings and will create the item in the list with all the properties.

But if I try to do this

body('Parse_JSON')?['assignedLicenses'][0]

for the licenses property then nothing seems to get created in the list.

It just runs and does nothing.

Thanks

Categories:

Business Process Flows

I have the same question (0)

All responses (10)

Answers (0)

pmwhelan 375 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

This is what i mean by "it runs and does nothing"

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

Dear pmwhelan,

Did you look into using the expression 'first()' to get the first array element?
This may help you.
More information:
https://manueltgomes.com/reference/powerautomate-function-reference/power-automate-first-function/

Please note, the syntax is a bit funny (it threw me off at the start .. but eventually you will get it).
Happy flowing, hope it helps,
Koen

Was this reply helpful? Yes No
pmwhelan 375 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

Finally got an error
Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'The template language expression 'body('Parse_JSON')?['assignedLicenses'][0]' cannot be evaluated because property '0' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

Was this reply helpful? Yes No
pmwhelan 375 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

Hi Koen
When I try
first(body('Parse_JSON')?['assignedLicenses'])
I get...
One or more fields provided is of type 'Null', a different type is expected.

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (0)

Report
Re: Is this the correct way to get the first element in an array from parseJSON?

Dear Pmwhelan,

Please view below an example of a correct syntax to grab an element out of the first entry in an array.
Check the syntax carefully. It seems to me you have not defined it correctly.

first(outputs('Lists_items_present_in_table_-_SO_9')?['body/value'])?['ProductName']
first(Array)?['element']
Happy flowing,
Koen

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

I just pasted an example of a correct syntax in the reply:
first(outputs('Lists_items_present_in_table_-_SO_9')?['body/value'])?['ProductName']

Was this reply helpful? Yes No
pmwhelan 375 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

Thanks.
I'm not sure how I apply that to a JSON value though?
This looks wrong?
first(body('Parse_JSON')?['assignedLicenses'])?['assignedLicenses']
but what should the second assignedLicenses be?
thanks

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (0)

Report
Re: Is this the correct way to get the first element in an array from parseJSON?

Dear Pmwhelan,

I assumed that the output from the 'Parse Json' action is an array, ... it is not an action I have used often. I have done some research and am now not so sure that the output is an array. If not, then the sugggested first() would not work.

If it is however an array, I would expect the syntax to be something like:
first(body/value('Parse_JSON'))?['assignedLicenses']
first(body('Parse_JSON'))?['assignedLicenses']

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

Are you able to show the output from your Compose action and Parse JSON action? If you click on the Code icon on the toolbar </> and paste it in the code editor, then we can look to see exactly what you need.

Was this reply helpful? Yes No
pmwhelan 375 on at

Like (0)

Report

Re: Is this the correct way to get the first element in an array from parseJSON?

When I go into that specific run of my flow that part is greyed out!
Can that be fixed?

Was this reply helpful? Yes No