Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

select query does not reduce data returned

(0) ShareShare
ReportReport
Posted on by

I want to limit the fields returned from sales force but when I put a list of fields I want returned Flow returns all the fields.

 

 

I've put this in the "Select Query" section in advanced options using spaces, commas, and semi-colons as the delimiter and no matter what I do it returns all the SF fields

 

Name, CreatedDate,pse__Account__c,pse__Is_Active__c,pse__Is_Billable__c,Schedule_Status__c,GEO__c

  • Re: select query does not reduce data returned

    I'm using the SharePoint "when record is modified" trigger. I can't et the image upload to work so hopefully one of these links will show the screenshot

     

    does the SQL get rows (and other SQL flow triggers) work with SharePoint?

     

     flow-pic

     

    here's the raw dropbox link https://www.dropbox.com/s/l9e2uqel4etui7f/sp-connector.png?dl=0

     

  • v-xida-msft Profile Picture
    v-xida-msft on at
    Re: select query does not reduce data returned

    Hi @drhomey,

     

    Could you please share a screenshot of your flow’s configuration?

    Do you use “Get rows” action of SQL Server connector?

    The data structure of my SQL Table as below:15.JPG

    I have made a test on my side and the flow works well. Please take a try with the following workaround:18.JPG

    Note: Within “Select Query” property, I typed two fields (Carline and StartYear). There is a comma and a space between Carline field and StartYear field.

     

    The flow works successfully as below:19.JPG

     

     

     

    Bets regards,

    Kris

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics