cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Time Issue - SQL DataSource

Hello Everyone,

I am developing an application which stores information about the users day to day daily tasks.

 

for this I am using DataSource: SQL Server

and because of that I am facing trouble in creating formulas which should be applicable.

 

I have an Edit form in which there is a Combo Box of Time only and when I select any particular time, the Detail From shows incorrect results and so as the Gallery.

ScreenShots:
Time Box, Items Property Formula
Time Box, Items: PropertyTime Box, Items: Property

Time Box, Update Property: Formula
Time Box, Update: PropertyTime Box, Update: Property

Time Box, Detail Form, Text: Property Formula
Time Box, Detail Form Text: PropertyTime Box, Detail Form Text: Property


I am kinda stuck in fixing this time thingy.

 

Need help!!

14 REPLIES 14

Dear sir @v-yutliu-msft ,

 

I have a flow for this, right now it's working and the report is being emailed to the user in PDF format, but the client said that the report should display there in powerapps.

 

any other way??

Hi @MH3 ,

Do you mean that you create a flow to send pdf content by using html text?

Then you could only display these html text in htmltext control in powerapps.

If you want to display pdf file in pdf viewer, you need to firstly use flow to create a pdf file, then upload this file to sharepoint or one drive.

5133.PNG

 

Then you could fill in the pdf viewer with the https link that you get from flow.

 

 

Best regards,

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.

Dear Sir,

@v-yutliu-msft 

Right now I have this Flow
Emailflow.png

before the Email, Flow what should I do ? because PDF has been generated in create file 2 and the content has been get by get file content.

what should I do to redirect the user to the OneDrive to view that PDF File???

Hi @MH3 ,

To get link of this pdf file, you need these actions:

5136.PNG

 

Create a link for this file and then response this link to powerapps.

 

 

Best regards,

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

Dear Sir,

@v-yutliu-msft 

I have done what you said, and it worked.

 

but I want to show the image in the report,

I have inserted an Img tag in html and pasted the google image picture inside it, but it's not showing in the report why? and not in HTML format as well

 
 
 

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (69,449)