Existing property doesn't exist on the SharePoint list

(0) Share

Report

Posted on by cmht

Hello,

I have a problem, my flow ran correctly by a few months.

I wasn't changing anything in the configuration, but now I get a message:

The execution of template action 'SelectBudgetHolder' failed: The evaluation of 'query' action 'where' expression '@item()['Budget_x0020_Holder']?['Email']' failed: 'The template language expression 'item()['Budget_x0020_Holder']?['Email']' cannot be evaluated because property 'Budget_x0020_Holder' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Title, (...).'.

of course property Budget_x0020_Holder is not listed above.

When I go to SharePoint list the column named:

Budget_0020_Holder

exists and has "people" selector field with possibility to select only one person.

Moreover, the previous step named "Filter array" shows that I have a value in Budget_x0020_Holder (I removed values below but they exist):

What may cause this problem?

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!
Most likely, a new record was created with an empty budget holder.

Making the field optional in your expression should fix the error:

item()?['Budget_x0020_Holder']?['Email']

Was this reply helpful? Yes No
cmht 82 on at

Like (0)

Report
Copy link

Link copied!

No, column contains values.
Flow only reads data, it is not saving it into SharePoint list, it saves outputs on SQL database - and this works.

I can't set field as optional as I require this value in the next steps.

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!

It could be that Excel defined the table to large, so some empty rows would appear at the end of your input or perhaps there are some empty rows that get passed unintentionally.

If you require the field to be filled, you can add an extra condition to filter rows without Budget holder in your filter array action (make sure it's the first condition so it's evaluated first).

Was this reply helpful? Yes No
cmht 82 on at

Like (0)

Report
Copy link

Link copied!

No. Excel table is not used in this flow.
BTW since yesterday it is unable to select any budget holder, so it is impossible to have it empty for 70+ people.

Flow gets all people from SharePoint list and has a filter query to cut off all offboarded people and those with 0% FTE. Each person has assigned Budget holder - and this field is later used for approvals (but flow stops on select BudgetHolder now)
In the next steps, it gets data from SQL table (one month) and there are no empty records. Flow creates HTML tables for ex:
John Doe:
11/1/2023 6h project A
11/2/2023 8h project B
Total hours: 14

and sends this information to budget holder to approve or deny the timesheet.

Was this reply helpful? Yes No
cmht 82 on at

Like (0)

Report
Copy link

Link copied!

I just realized that my Filter array action is not returning Budget_x0020_Holder while it should.
Some time ago it worked fine. I will focus on a previous step instead on "Select" action.

Was this reply helpful? Yes No
Verified answer

cmht 82 on at

Like (0)

Report
Copy link

Link copied!
The reason was that in the Select outputs from filter array I had:
item()?['Budget_x0020_Holder']?['Email']
and this should be:
item()?['Budget_x0020_Holder/Email']
Now my flow works fine.

Was this reply helpful? Yes No