web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / What kind of data sour...
Power Apps
Answered

What kind of data source do you recommend?

(0) ShareShare
ReportReport
Posted on by 10

I have those requirement.

1. using pen input for signature

2. export form to PDF file which the signature was include.

3. email PDF file which was from item.2

4. those form and the signature can be queried in feature

 

So what kind of data source do you recommend?  

Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,923 on at

    With emailing PDF and Exporting PDF, Sharepoint will cover all.

     

    If you want to use any other Datasource such as excel or SQL, you will need Onedrive for Business in addition to be able achieve the export PDF.

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Hawk_Lee Profile Picture
    10 on at

    Hi eka,

     

    Thank you for your information.

     

    How about the signature? What data type should I use to save it?

  • eka24 Profile Picture
    20,923 on at
    SharePoint or Ondrive
    Watch https://youtu.be/UdbNqQ1z_Ww
    On signature.

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @Hawk_Lee :

    Taking into account your needs, I think that using different data sources has different advantages.

    SharePoint- When you are generating HTML text, you can directly use the RUL of the picture

    CDS- You can directly store the picture in the data source

    Important: At first, glance does not seem to work as when viewed in a Model-Driven app the image is all black. What happens is that the pen input as default has a transparent fill color, which is not supported by CDS entity images. To make it work, set Pen input fill color to white or another color of your choice. PowerApps Pen Input – Have issues? Problem solved!

    Considering the ease of use, I would like to introduce a method that uses SharePoint as a data source, but does not require flow to store pictures.

    I’ve made a test for your reference.

    using pen input for signature

    My data source:test

     

     

    Column (click to edit)

    Type

    Title

    Single line of text

    signature

    Hyperlink or Picture

    Modified

    Date and Time

     

    step1:add a new mode form control(Form3)

    set the attachment control’s items property to: MyPics /*my custom collection*/

    set the attachment control’s Value property to:Value(advanced-DATA-Value)

    You can refer to this case

    step2:add a PenInput control(PenInput1)

    Step3:add a button and set it’s OnSelect Property to:

     

    ClearCollect(
     MyPics,/*create a collection to save the pic*/
     {
     DisplayName: Concatenate(
     "image",
     Text(
     Now(),
     "[$-en-US]yyyy-mm-dd-hh-mm-ss"
     ),
     ".jpg"
     ),
     Value: PenInput1.Image,
     AbsoluteUri: "",
     Id: "00000000-0000-0000-0000-000000000000"
     }
    );
    SubmitForm(Form3);
    Patch(
     Test,
     First(
     Sort(
     Test,
     Modified,
     Descending
     )
     ),
     {
     signature: First(
     First(
     Sort(
     Test,
     Modified,
     Descending
     )
     ).Attachments
     ).AbsoluteUri
     }
    )

     

    export form to PDF file which the signature was include.

    Step1:Add a HtmlText control and set it’s HtmlText property to:

     

    "<!DOCTYPE html>
    <html>
    <body>
    <h2>PDF Report Example</h2>
    <h2>"&First(Sort(Test,Modified,Descending)).Title&"</h2>
    <div>"&"<img src="&First(Sort(Test,Modified,Descending)).signature&">"&"</div>
    </body>
    </html>
    "

     

    1.png

    Step2:Creat your flow(follow this video)

    I think this link will help you a lot:

    https://blog.muhimbi.com/2017/08/convert-powerapps-data-to-pdf.html

     

    Best Regards

    Bof

  • Hawk_Lee Profile Picture
    10 on at

    Hi @v-bofeng-msft 

     

    Thank you for your so detail description and I am really really really thanks for that.

     

    I don't have any coding experience just only my company order Office E3 plan so I want to use it as well as I can then I saw a PowerApp introduction video and someone said he didn't have any coding skill like me but he only spent 4 hours to build a APP for his company then he inspire me at that time then  I spent more than 4 days but I still cannot build a app can go production use.

     

    Thank you for your sharing and I will try it recently.

     

    BR,

    Hawk 

  • Hawk_Lee Profile Picture
    10 on at

    It can work, but I face another issue which is if my Powerapp form's  content had double byte characters then convert to PDF will fail and I found IDEA web site had a request was provided at 2018 so I convert to JPEG file then I can see the correct content.

     

    When I use text input with multiple line as source to be another HTMLtext how can I keep the line break and turn into HTML code as <p> or <br>??

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard