Answered

Array option caused error

(0) Share

Report

Posted on by Violet1

Hi,

I have a flow that sends an email on weekly basis. I added a new item 'Site' which is now causing error"{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value")

I understand that this is caused by a column with a dropdown options.

I am hesitant to fix this issue as I don't want to break the flow. any assistance would be greatly appreciated.

thank you

All responses (5)

Answers (1)

Verified answer

Violet1 31 on at

Like (1)

Report

Re: Array option caused error

Hello,
I actually added "Site_value" instead of "Site' and now the flow is working without an error

thank you
Violet1 31 on at

Like (0)

Report

Re: Array option caused error

hi,
the dropdown for site is part of the list that i have created. i just wanted the site to be added to each email.
Rhiassuring 8,688 Super User 2025 Season 1 on at

Like (0)

Report

Re: Array option caused error

Were you hoping to add the dropdown value into the area where you have (Site_)?

Is Site_ a multi-select column? Or a lookup column? (Or both?)
Violet1 31 on at

Like (0)

Report

Re: Array option caused error

hello,
yes, I thought I selected all screenshots. here are remaining screenshots
Rhiassuring 8,688 Super User 2025 Season 1 on at

Like (0)

Report

Re: Array option caused error

Hi,

Did you intend to post more screenshots? I don't see any 'Site' reference.

It will also be helpful to see what your expressions are.

Cheers,

Rhia