Execute Stored Procedure (V2) - Parameter Q&A

(0) Share

Report

Posted on by Sach2022

Hi,

I have a SQL SP that can take date values, i.e. @From and @TO

How do I pass in parameters such as: ( cast([Visitor].[Arrivaldatetime] as date) between cast(getdate()-8 as date) and cast(getdate()-1 as date) ) - in other words for @From I want to pass in today()-8 and @TO to be Today()-1 ?

Please help.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sach2022 ,

It it a powerautomate question?

Do you want to pass date from flow to stored procedure while the flow is running?

If so , you could try this:

If you want to get the date 8 days ago, you could use this expression:

formatDateTime(addDays(utcNow(),-8),'yyyy-MM-dd')

If you want to get the date 1 days ago, you could use this expression:

formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')

Best Regards,

Wearsky

Was this reply helpful? Yes No
Sach2022 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.
Just like your screenshot, my SP accepts a few more Params, but the other two are integers and I wish to leave them either as any or null. While you are at it, how do I specify <>blank (i.e. is not blank, or has an integer value) and null for integer Param types?
Thanks.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sach2022 ,

Sorry i didn't understand your needs.

Could you explain it?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Sach2022 56 on at

Like
a
(0)

Report
Copy link

Link copied!

I've since done it now, thanks for your help. I will accept as a solution. Cheers.

Was this reply helpful? Yes No