cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jup
Helper II
Helper II

Using SQL functions

Hi all,

 

I've just created a function in mssql:

 

1.PNG

 

This function delivers a table for 1 year with all german public holidays:

2.PNG

Great!!

... now I want to check in PowerApps wether a date (single day // eg.: "2019-06-27") is a public holiday. So I have to call the sql-function like this:

 

3.PNG

 

But how can I achieve this?

I have to call the sql-function with the YEAR ("2019") and the day date ("2019-01-01").

I want to get the fields "istFeiertag" and "feiertag" as result to display it on a text label in powerapps.

 

Any idea?

 

thanks in advance!

joerg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @jup ,

I'm afraid it's not suppoeted to call SQL functions currently in PowerApps.

I suggest you express your views on PowerApps Ideas Forum. Your precious advice will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

As an alternative way, I suggest you use PowerApps functions to make this.

For example, if you want to get "istFeiertag" and "feiertag" from one specific item(date ("2019-01-01"), you could use this formula:(set it the label's Text)

LookUp(tablename,datum=Date(2019,01,01),istFeiertag)

LookUp(tablename,datum=Date(2019,01,01),feiertag)

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
RandyHayes
Super User III
Super User III

@jup 

Calling a table based function in PowerApps is not currently supported.  There is an Idea on the idea forum that you might want to go and vote on for this.

 

That said, you could come up with some workarounds to perhaps utilize Flow for this and possibly also Azure Functions, but doing it directly is not an option.

 

I hope this provides some help for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
v-yutliu-msft
Community Support
Community Support

Hi @jup ,

I'm afraid it's not suppoeted to call SQL functions currently in PowerApps.

I suggest you express your views on PowerApps Ideas Forum. Your precious advice will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

As an alternative way, I suggest you use PowerApps functions to make this.

For example, if you want to get "istFeiertag" and "feiertag" from one specific item(date ("2019-01-01"), you could use this formula:(set it the label's Text)

LookUp(tablename,datum=Date(2019,01,01),istFeiertag)

LookUp(tablename,datum=Date(2019,01,01),feiertag)

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,483)