Answered

Filter SQL Server on-premises with datetime

(0) Share

Report

Posted on by Trinaintynine

I am creating a flow to return a certain row, in the flow i need to filter by datetime (date with time). how do i achieve that ? I need to get data from 'counter=2' where i can't use this condition as filter query because it will integrate to Microsoft Form and User doesn't need to input/know the unique ID, on my form for filter are "Date" component as the Time I am using a "Text" component

Iam using server on prem

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

v-bacao-msft on at

Like (0)

Report

Hi @Trinaintynine,

What do you mean by using the time the user fills in the form as a filter to get rows?

You could use the corresponding Dynamic content of the Forms output as a condition.

Image reference:

Best Regards,

Was this reply helpful? Yes No
Trinaintynine 78 on at

Like (0)

Report

Thanks for replying

In my case is about user/client do a shifting time to teach a class, so they need to input the date and time when they're available to teach. and in my flow in need to search if the class is available or not.

so in my form, I made this question.

the problem is how do i filter column "Time Start with these answer" ? , for now I'm trying to filter it by "convert those answer into converttotime". but i keep on failing to convert it

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Hi @Trinaintynine,

You could use Expression to organize the user-submitted Cover Date and Cover Time into the same format as the timeStart column, and then configure Filter query.

Expression reference:

concat(body('Get_response_details')?['r2688fcec52ca4f0ca9df50a360a16e2d'],' ',concat(body('Get_response_details')?['r28eb1dc8d0eb408786cc0f52e0f7f58b'],'.000'))

The parameters in Expression are configured using Dynamic content in your Flow. The second parameter is a space.

Finally, the time of Compose output is used as a filter condition. Note that need to add single quotes to the outside.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Verified answer

Trinaintynine 78 on at

Like (0)

Report

thanks for your answer..

somehow i find a post with another filter syntax. and i have tried it and it works too
here's the following

Was this reply helpful? Yes No