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 / SharePoint Connector f...
Power Automate
Answered

SharePoint Connector for applying a condition

(0) ShareShare
ReportReport
Posted on by 9

Hello,

 

I am trying to make a chatbot in Power Virtual Agents and need to add information to a SharePoint list. I have given the user 3 questions and saved the results to send through Power Automate. Which I have setup like this:

nicolabooth_0-1671098275131.png

What I need to achieve is:

nicolabooth_1-1671098346189.png

As I don't want duplicate entries into the SharePoint List, my theory was to apply a condition based on the column in SharePoint and compare that against the user's input.

However, what connector would I place before the condition to simply load up the information from the SharePoint list to allow me to use the column name in the condition?

nicolabooth_2-1671098522212.png

I am aware that what I have in place currently wouldn't work because it's a trigger, just for the purposes of demonstration.

Any help would be greatly appreciated.

Kind Regards

Nicola

 

Categories:
I have the same question (0)
  • Verified answer
    nicolabooth Profile Picture
    9 on at

    nicolabooth_0-1671110969948.png

    Found a solution to my own issue thanks to a colleague I work with. Needed to use Get Items and filter by a column name and then apply a Length expression to determine True / False for the condition. Hope this helps someone else. 😀

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 223

#2
David_MA Profile Picture

David_MA 195 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 167

Last 30 days Overall leaderboard