Cannot index into a null array- Power automate

Question

I'm using power automate to return user profile data from AAD via graph api. My calling graph api query

https://graph.microsoft.com/v1.0/groups/groupid/members?$select=displayName,city,department,businessPhones,jobTitle,officeLocation,mail,mobilePhone,createdDateTime&$top=2

Some users have the field businessPhones empty (See json below).

{
        "@odata.type": "#microsoft.graph.user",
        "displayName": "DXu Po",
        "city": "Ondo",
        "department": "Design",
        "businessPhones": [
          "93625613000"
        ],
        "jobTitle": "Designer",
        "mail": "comradecom.au",
        "mobilePhone": null,
        "createdDateTime": "2019-09-18T05:54:26Z"
      }

I tried the below to check if the field is empty and if yes insert null

if(empty(items('Apply_to_each_2')?['businessPhones'][0]),'[]',null)

But still getting the same error. Any ideas what i'm missing here. Thanks in Advance

Bharat Khunti · Accepted Answer · 2024-09-27 06:19:03Z

1

Based on above condition it's look like when businessPhones empty it's returning '[]' and when not empty it's returning null. Based on your description your condition should look like something below

if(empty(items('Apply_to_each_2')?['businessPhones']?[0]),null,items('Apply_to_each_2')?['businessPhones']?[0])

added ? to avoid null error

edited Sep 27, 2024 at 6:19

answered Sep 24, 2024 at 6:38

Bharat Khunti

9059 silver badges21 bronze badges

Thanks Bharat. That did the trick not sure what i was thinking

naijacoder
– naijacoder

2024-09-26 00:16:46 +00:00
Commented Sep 26, 2024 at 0:16

Add a comment |

Stack Exchange Network

Cannot index into a null array- Power automate

1 Answer 1

Your Answer

Hot Network Questions

Cannot index into a null array- Power automate

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions