web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Get rows from sql quer...

Power Automate - Building Flows

Answered

Get rows from sql query and update sharepoint list.

(0) Share

Report

Report

Posted on by shravanreddy13

23

Hi ,

I'm trying to run a sql query in power automate and update a sharepoint list.

Query is:

Select sJobID,sJobQuickDesc, sContactEmail,emp.Name from tblsv_job job
left join tblSystem_Employee emp on emp.EmployeeID = lOwnerID
left join tblsv_activity act on act.lJobID = job.lJobID
where CAST(dtClosed AS DATE) = CAST(GETDATE() AS DATE) and iLineType <= 1

dtclosed is a datetime field . convert this to date field and check if equal to todays date.

The conversion doesnt work. Gives me a syntac error. ALso, How do i use the joins with other tables in get rows action?

any help is much appreciated.

Cheers,

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

lbendlin 8,332 Super User 2025 Season 2 on at

Like (0)

Report

Re: Get rows from sql query and update sharepoint list.

Create a view on your SQL server that has your query logic, and then use the "Get Rows" action against the view. No need for extra filters.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 797 Super User 2025 Season 2

#2

Tomac 425 Moderator

#3

developerAJ 319

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans