Power Automate - Building Flows

Unanswered

Power AUtomate : Select option - Item() function : GIves nulls in output

(0) Share

Report

Posted on by NarenCh1

Hi, I am using SELECT option in Flow, and using item() in the expression to read value from previous step.

I am getting NULLs as output.

QUery from previous step is below:

// DAX Query

DEFINE

VAR __DS0Core =

FILTER(

KEEPFILTERS(

SUMMARIZECOLUMNS(

'Sheet2'[Mobile Number],

'Sheet2'[Customer Name],

'Sheet2'[Region],

'Sheet2'[City],

'Sheet2'[Address],

'Sheet2'[Network Status],

'Sheet2'[Expected Uptime],

'Sheet2'[Technician Name],

'Sheet2'[Network Traffic],

'Sheet2'[Weather Condition],

'Sheet2'[Issue Reason_1],

'Sheet2'[Tower id ],

'Sheet2'[Network status bar],

"MinNetwork_Status", IGNORE(CALCULATE(MIN('Sheet2'[Network Status])))

)

OR(

NOT(ISBLANK('Sheet2'[Mobile Number])),

NOT(ISBLANK('Sheet2'[Customer Name]))

NOT(ISBLANK('Sheet2'[Region]))

NOT(ISBLANK('Sheet2'[City]))

NOT(ISBLANK('Sheet2'[Address]))

NOT(ISBLANK('Sheet2'[Network Status]))

NOT(ISBLANK('Sheet2'[Expected Uptime]))

NOT(ISBLANK('Sheet2'[Technician Name]))

NOT(ISBLANK('Sheet2'[Network Traffic]))

NOT(ISBLANK('Sheet2'[Weather Condition]))

NOT(ISBLANK('Sheet2'[Issue Reason_1]))

NOT(ISBLANK('Sheet2'[Tower id ]))

NOT(ISBLANK('Sheet2'[Network status bar]))

)

VAR __DS0PrimaryWindowed =

TOPN(

501,

__DS0Core,

'Sheet2'[Customer Name],

'Sheet2'[Mobile Number],

'Sheet2'[Region],

'Sheet2'[City],

'Sheet2'[Address],

'Sheet2'[Network Status],

'Sheet2'[Expected Uptime],

'Sheet2'[Technician Name],

'Sheet2'[Network Traffic],

'Sheet2'[Weather Condition],

'Sheet2'[Issue Reason_1],

'Sheet2'[Tower id ],

'Sheet2'[Network status bar],

)

EVALUATE

__DS0PrimaryWindowed

ORDER BY

'Sheet2'[Customer Name],

'Sheet2'[Mobile Number],

'Sheet2'[Region],

'Sheet2'[City],

'Sheet2'[Address],

'Sheet2'[Network Status],

'Sheet2'[Expected Uptime],

'Sheet2'[Technician Name],

'Sheet2'[Network Traffic],

'Sheet2'[Weather Condition],

'Sheet2'[Issue Reason_1],

'Sheet2'[Tower id ],

'Sheet2'[Network status bar]

The expression in select is

item()?['Sheet2[Customer_Name]']

This gives NULL

I have the same question (0)

All responses (4)

Answers (0)

Pstork1 68,306 Most Valuable Professional on at

Like (0)

Report

Re: Power AUtomate : Select option - Item() function : GIves nulls in output

Power automate uses JSON notation. Try item()?[ 'Sheet2']?['Customer_Name]'

Was this reply helpful? Yes No
NarenCh1 4 on at

Like (0)

Report

Re: Power AUtomate : Select option - Item() function : GIves nulls in output

Hi Pstork1 , tried the way you mentioned, but it is still throwing error:
the Input :
[
  {
    "Sheet2[Mobile Number]": "(315) 779-5021",
    "Sheet2[Customer Name]": "Amanda Brown",
    "Sheet2[Region]": " Midwest",
    "Sheet2[City]": " Chicago",
    "Sheet2[Address]": " 5678 Oak St",
    "Sheet2[Network Status]": "No network",
    "Sheet2[Expected Uptime]": "60min",
    "Sheet2[Technician Name]": "Richard Romero",
    "Sheet2[Network Traffic]": "Low",
    "Sheet2[Weather Condition]": "Stormy",
    "Sheet2[Issue Reason_1]": "Network Failures",
    "Sheet2[Tower id ]": "T-0004",
    "Sheet2[Network status bar]": 0,
    "[MinNetwork_Status]": "No network"
  },

The output:

[
  {
    "Customer Name": null
  },

Was this reply helpful? Yes No
NarenCh1 4 on at

Like (0)

Report

Re: Power AUtomate : Select option - Item() function : GIves nulls in output

Is there a way to use items()
I have come across a video, and using that video, I am trying solution to send customized emails when an alert takes place.
it uses items(). But when i use it , it throws error that the parameter is not provided.

Error: "The template language function 'items' must have at least one parameter.".

the expression , I am passing is
items()?['Sheet2[Customer_Name]']

Was this reply helpful? Yes No
Pstork1 68,306 Most Valuable Professional on at

Like (0)

Report

Re: Power AUtomate : Select option - Item() function : GIves nulls in output

If you are doing a Data Select it would be item(). Items('Actionname')?['Field'] is used to reference an array of items in something like an Apply to each loop. this post explains the difference. 📝Understanding the Item() and Items(‘Apply_to_each’) Functions in Power Automate with Examples – Ellis Karim's Blog

Was this reply helpful? Yes No