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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Value is in sharepoint...
Power Automate
Unanswered

Value is in sharepoint list

(0) ShareShare
ReportReport
Posted on by 4

i have a form that is submitted with the sends email address. The form is public. I want to check the submitters email address against a share point list of authorized submitters. If the email address is in the Authorized Agent list they receive an email confirming their submission. If the submitter is not a registered Authorized Agent I want to send the submitter an email stating as such. The power automate condition works fine if they are in the list. If they are not, the flow stops. It doesn't send the email for the "No" valuefilter queryfilter queryCondition statementCondition statement 

What am I doing that the flow stops when the submitters email isn't in the sharepoint list?

I have the same question (0)
  • rjmillerCAK Profile Picture
    4 on at

    the value of the response shows up as 

    "body":{"value":[]}
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @rjmillerCAK 

     

    Once you use get items with filter query to filter out email addrees , you will get an output whether the form submitter is authorizer sender or not, so using the step below in your flow 

    Nived_Nambiar_0-1683772608518.png

     

    does not make any sense as it will work when email addrees is autorized sender , as value contains only the email address.

     

    To make it work , let's replace the above step with this below (making it simple )

     

    Nived_Nambiar_1-1683772800915.png

     

    in the condition we are checking this, whether the output / value dynamic content is having values in it or not. 

     

    if the above condition is true, then it means that submitter is non autorized person 

    if the above condition is false, then it means that submitter is autorized person.

     

    condition expression: 

    length(outputs('Get_Email_of_Autorized_Agents')?['body/value'])
     
     
    Hope it helps !
     
    Mark it as solution if it resolves your query !
     
     
  • rjmillerCAK Profile Picture
    4 on at

    Thank you for the response Nived. I'm still getting the same response. 

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @rjmillerCAK 

     

    could you share a screenshot on how you have designed the flow ?

     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 412

#2
Vish WR Profile Picture

Vish WR 305

#3
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

Last 30 days Overall leaderboard