Select Statement Saying my property doesn't exist

(0) Share

Report

Posted on by npinot2002

My flow starts off with a 'run a query against a data set'

And then I created an array using Range because the client wants this to exported to an excel file and have index

Due to some other business requirements the row #'s have to start at 2 which is the first map in the select statement.

When I run the flow it gives me this error

My data displays perfectly after the 'Run a query against a dataset', and the error message seems to change which fields are available every time I run the flow. Also the data set is less than 100,000 cells

Categories:

Business Process Flows

All responses (1)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Re: Select Statement Saying my property doesn't exist

Hi , @npinot2002

Your error code is here , this may happen when your ['By RIP[GSA Comparison]'] has no value.

So , you need to add '?' in this expression:
outputs('Run_a_query_against_a_dataset')?['body/firstTableRows']?[item()]?['By RIP[GSA Comparison]']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang