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 / Determine and send out...
Power Automate
Unanswered

Determine and send outlook email if a field value in certain Salesforce Projects equals any value on Excel List

(0) ShareShare
ReportReport
Posted on by

I have an excel list of 100 or so Product Numbers that are flagged and should not be re-used. I want an email notification if someone creates a Project with Product Number = anything on my flagged list.

 

I need to pull from Salesforce all Custom Media Projects that have the Field: "Designer" = someone on my team

where, my team = "name1,name2,name3"  

 

I'm unable to create an array from the excel list.  I feel like this shouldn't be that hard... see my attempt in screenshots.  

 

More importantly, I'm not sure on the best way to pull the specific data I need from Salesforce (ideally the output is a row for each CMP, where Column2: Product Number and Column3: Designer).  The "Get Records" seems to be the correct function.  I can't fill out "filter query" and "select query" properly and it is my main issue. 

 

If I run Get Records, I can see the raw data output and figure out the names of the fields, i.e. Designer__c, Product_Number__c, or RecordTypeId.  How do field names get formatted in Filter Query expressions?  I keep getting "the expression is invalid"

for example: RecordTypeId equals 'Upstream Consumables' didn't work.
 
Any help is appreciated.
Categories:
I have the same question (0)
  • Jronash Profile Picture
    827 on at

    I think you forgot to post your screenshot.

  • Community Power Platform Member Profile Picture
    on at

    @Jronash yes my bad, here you gocreatearrayPA.png

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard