Skip to main content

Notifications

Community site session details

Community site session details

Session Id : HR8de8QIwvywVlyUqLrCsg
Power Automate - Using Connectors
Unanswered

select query does not reduce data returned

Like (0) ShareShare
ReportReport
Posted on 14 Nov 2017 19:48:22 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

  • Community Power Platform Member Profile Picture
    on 20 Nov 2017 at 17:28:25
    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
    on 15 Nov 2017 at 08:17:52
    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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard

Featured topics

Loading started