@WarrenBelz
Hello Warren,
Thank you for the response. I really appreciate it. Apologies in advance for the length of this post, but I really want to learn your technique and want to make it as easy as possible for you to spot what I am doing wrong right away out of respect for your time.
Per your advice, I changed the URL in my Image control from a .png to a .jpg extension.
"https://quickchart.io/qr?text="& EncodeUrl("https://apps.powerapps.com/play/e/default-xxxxx?tenantId=xxxx&hidenavbar=true&DeepLink=AdminScreen&RefID=" & varRecord.ID & ".jpg")
OnSelect formula of my 'Create Box Label PDF' button to the formula you gave me. There are no error/red lines.
With(
{
wJSON:
JSON(
Image4.Image,
JSONFormat.IncludeBinaryData
)
},
Set(
varBlob,
Mid(
wJSON,
Find(
",",
wJSON
) + 1,
Len(wJSON) -
Find(
",",
wJSON
) - 1
)
)
);
Patch(
'CSO Archive Requests',
{
ID: varRecord.ID,
'Generate PDF': true,
'PDF Version': Value(valPDFVersion.Text) + 1,
'PDF Email': varUser.Email,
QRCodeML: varBlob
}
);
Notify("A box label will be sent to your email and attached to the record shortly.", Success)
The Default and Update properties of the data card are still set to:
Default: ThisItem.QRCodeML
Update: varBlob
My flow trigger is still 'When an item or a file is modified' since I don't want my app to be converted to a Premium license app. I really don't need to store the .jpg files in a SharePoint doc library for all posterity so I just added a OneDrive 'Create file' step.
When I run the flow, it breaks at the Create file step. It says it cannot be evaluated because 'Createfile_FileContent' doesn't exist and then goes on to give a list of things I can choose from. QRCodeML is the name of my multi-line text column.
When I added a 'Get file content using path' step. File content wasn't one of the dynamic content options to choose from. File locator and Path were the 2 closest options. I'm doubtful this step will work, but it is untested since the flow breaks at the Create file step.
When this approach didn't work out, I went back to your blog to follow the steps for uploading an image to a SharePoint doc library calling the flow from SharePoint. It all seemed to go pretty smoothly until I inserted a new button in my app to call the flow from. This is the formula for the OnSelect. What am I doing wrong?
Here are the steps I constructed based on your very detailed blog post (thank you). I didn't add any Word doc steps as, again, I don't want to risk turning my app into a premium license app, but I thought I could at least experiment to see if I could get the QR code converted into a usable file that could later be inserted into the Word doc flow by pulling it down from the SharePoint doc library location via a "ParentID" tie in. I added a number type column to my doc library named "ParentID". Can you let me know how I could pass the ID from the Power Apps record I am into the SharePoint doc library? Seems like it would have to be passed in the flow run, versus a Patch statement that falls after the flow run, but I'm not sure how to add that in.
I noticed a small discrepancy between this step and the step shown in your blog post. Mine reads Title and Description. Your screenshot reads Title and IDRef. Not sure if that is significant or not, but thought I would mention it.
Add attachment Id expression.
Add attachment File Name expression.
Technically, I don't really need to add the attachment to the record, but I am trying to learn from your post as I would really like to nail down the technique for future projects. Please let me know if I got any of these steps wrong. I really appreciate your help, Warren. Thank you so much for your patience.
Teresa
