web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : smw7daJJRXHwPRtsLXpHfo
Power Automate - Using Flows
Answered

Array option caused error

Like (0) ShareShare
ReportReport
Posted on 14 Aug 2022 23:56:23 by 31

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 youpowerautomate_1.png

 

  • Verified answer
    Violet1 Profile Picture
    31 on 19 Aug 2022 at 00:06:58
    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 Profile Picture
    31 on 17 Aug 2022 at 23:18:54
    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. Powerautomate_email_site.JPG

  • Rhiassuring Profile Picture
    8,688 Moderator on 17 Aug 2022 at 00:50:56
    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 Profile Picture
    31 on 17 Aug 2022 at 00:43:41
    Re: Array option caused error

    hello,

    yes, I thought I selected all screenshots. here are remaining screenshotspowerautomate_4.pngpowerautomate_3.pngpowerautomate_2.png

  • Rhiassuring Profile Picture
    8,688 Moderator on 17 Aug 2022 at 00:18:28
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete