Video

wow this is useful!

Thank you for this two-part series! You explained every aspect and supplied free code! Amazing!

thank you so much!

That is super helpful, thank you for the video. One question though: if I need to select specific data (not just one or all of them), let's say I only need the active workers' reports and not all the workers' reports in the file, how should I do it?

Is it possible to email the pdf instead of save? So that is 10 different email address if 10 records based on the email line of the record

When I heard VBA …I got scared. But I followed through lol. I am going to test on my side. My data is not in a simple list but in a template form that is similar

Its working for me but Its only copying the files in the folder, how do you get it to copy the whole folder? for example in my Source folder I have new folders created from a JotForm this works but instead of copying the whole new folder, it copies just the files within it?

I need you help

I really like this approach. Also you have a very cool signature 👍🏼

PDF Files uploaded to OneDrive are not working. Size of auto saved PDF files are less than 5KB, corrupted. How to fix this?

how to define. the schema if the response is a json array? for example { addresses: [{}] } ?

Thank you so much!

thanks a lot sir!

hey mate , good stuff, is there a way to store the SharePoint link for the new document in Dataverse for back office proposes , if yes , how to do that ?

I'm building a housing app that has a lot of payment dates, checkin and checkout dates. I was using a dynamic calendar to track them all but this now has me thinking a status bar view dashboard might be just the thing these users would love.

Well Done and very informative. TY Henry. I'll be sure to check out your website as well.

AMAZING!!! I finally got an long term issue solved thanks to you!

Are you Vietnamese, your voice is so nice!

Nice !

Thank you Henry

Tks a lot, how to do that using dynamic OneDrive Account folder ?

PASTE THE CODE IN THE DESCRIPTION OR PIN IN THE COMMENT ** LISK IS NO MORE WORKING **

PASTE THE CODE IN THE DESCRIPTION OR PIN IN THE COMMENT ** LISK IS NO MORE WORKING **

"Ask in PowerApps" option is missing under add dynamic content option. its showing only " body". please suggest

Is there a way to save the barcode to sharepoint list?

The link does not work - please post link

Thanks for the amazing video, Best solution I saw online. The link for the code doesn't seem to work, could you add it again ?

thx for the help me , if success im follow u all over

Can you make a macro to make multiple pdfs out of websites using an excel list with a column with names for the pdfs and a column of websites?

Is this the only way to set the product name to automatic?

Thoroughly enjoyed! Cleared so many concepts in small time. Thank you so much for sharing this!

Worked great for me. Thanks a lot Henry! Since the link Henry shared is dead, here comes the code with emoji "🤔" that need to be changed dependent on your worksheet. Sub Generate() Dim wsA As Worksheet Dim wbA As Workbook Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On Error GoTo errHandler Set wbA = ActiveWorkbook Set wsA = ActiveSheet Application.DefaultFilePath = "🤔" strFile = Range("🤔").Value & ".pdf" strPathFile = Application.DefaultFilePath & strFile wsA.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=strPathFile, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False exitHandler: Exit Sub errHandler: MsgBox "Oops something went wrong! " Resume exitHandler End Sub Sub GenerateAll() Dim i As Integer For i = 1 To Range("🤔").Value Range("🤔").Value = i Call Generate Next i End Sub

Sorry I dont understand 😁 Where is the pdf anyway?

9:11 I hate that notification sound

But what is macro code for generate pdf

You absolutely help my task Henry, thank you so much

Hi Henry, I recently watched your video on how to scan and store barcodes in SharePoint using Power Apps. I found it to be very informative and helpful, so I wanted to take a moment to express my gratitude for your efforts in creating such a valuable resource. I have a specific question regarding an existing SharePoint list. Suppose I have a list that is already populated with data, but it lacks a barcode and a running number. I would like to add these two fields to the list, with the running number serving as the barcode. Could you please provide some guidance on how to accomplish this? Thank you once again for your insightful video. I look forward to your response. Best regards

Hey Henry, is there a way to convert a large .xlsx file to a smaller .xlsb format prior to downloading? my files that come in daily are 50mb or greater and it doesn't appear that it will work on those sizes

How did you´ve created the items on 03:45:00?

Hi Henry, On it... Stupid question, but the form supports all characters (e.g. Chinese, Arabic)?

So Awesome, Henry!! Thanks a ton. I'm a novice and you made this soooo easy. Only thing I'm having trouble with is saving the pdf's to a network (MS Sharepoint) file path that start out . Can this be done? Thanks!

Hello, i have a question, would it be possible if printing all records into one pdf (each page is a record)? would be greater even! thanks for this so much!

User this Patch('Automated Scan',{Item: BarcodeReader1.Value, Whoscanned: User().FullName, Time: Now()}) not working

If other filters used it will still show 0 whats the point??

Possible to save pdf file in the path name on the range

If i want to email this created word document what should be my next step

This video's is very helpfull me.. I appreciate nd glad for watching your video... make more video for example powerautomate

great function!!! used it to cut 2x time, and after reading through the network tab i moved some querys out from the submit button into text boxes and saved in total 10x time from the original sync time - from 17-20 sec to 2.5 sec!!! huge thanks!!

Thank you for the info, tried it several times but it will not work for me. Item: BarcodeReader2.Value, WhoScanned: User().FullName, Time: Now()}) Always gives me an error message saying Value is not accepted. Any suggestions?