Time Issue - SQL DataSource

[MH3]

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: Property

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

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

I am kinda stuck in fixing this time thingy.

Need help!!

[MH3]

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??

[v-yutliu-msft]

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.

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

Best regards,

[MH3]

Dear Sir,

@v-yutliu-msft 

Right now I have this Flow


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???

[v-yutliu-msft · Accepted solution]

Hi @MH3 ,

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

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

Best regards,

[MH3]

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