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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Array option caused error
Power Automate
Answered

Array option caused error

(0) ShareShare
ReportReport
Posted on 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

 

Categories:
I have the same question (0)
  • Rhiassuring Profile Picture
    8,690 Moderator on at

    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

  • Violet1 Profile Picture
    31 on at

    hello,

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

  • Rhiassuring Profile Picture
    8,690 Moderator on at

    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 at

    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

  • Verified answer
    Violet1 Profile Picture
    31 on at

    Hello, 

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

     

    thank you

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 170 Super User 2025 Season 2

Last 30 days Overall leaderboard