Powerapps V2 trigger MS Flow, (INPUT "File" type issue)

(0) Share

Report

Posted on by Kepcla

Hi Team,

I ´ve created a MS flow (see images below).

But the code in my button inside Powerapps, is not working, I´ll try with two codes:

1) PDF_OC_RTME_F.Run("Test"&".pdf",Html_Resumen_4.HtmlText,To_Emails.Text,Gallery9.Selected.Proveedor,Body_Emails.Text,{file:First(Orden_Compra).Attachments.AbsoluteUri})

2) PDF_OC_RTME_F.Run("Test"&".pdf",Html_Resumen_4.HtmlText,To_Emails.Text,Gallery9.Selected.Proveedor,Body_Emails.Text,{file:DataCardValue32.Attachments.Value)

It says: Incompatible type, the "file" column in the data source you´re updating expects a "Record" type and you´re using a "Table" type.

in this second image, if you set the variable to "Object" , the system display an error as well.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Kepcla ,

Currently, this is a known issue.

Please consider passing base64 or datauri instead of passing binary file directly.

Then you could use base64tobinary or datauritobinary function in flow to convert it .

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Kepcla on at

Like (0)

Report
Copy link

Link copied!

Long road, but it works!

Was this reply helpful? Yes No
DGS 122 on at

Like (0)

Report
Copy link

Link copied!

How do you do this?

Was this reply helpful? Yes No
MattB1984 2 on at

Like (0)

Report
Copy link

Link copied!

I have spent a good part of a day, trying to work out why every time I send a PDF of a container via the Power Automate V2 trigger it arrives in my sharepoint folder with no content.

The answer is I just needed to create the PDF as a variable first:

Set(varPDFex, PDF(Container1, {ExpandContainers: true, DPI: 128}));

Then when i passed this to powerautomate using the flow function:

InspectionReportFlow.Run(
Concatenate(
Text(Now(),"yyyymmdd.hhmmss"),
"-",
H_AssetID.Text,
" - Inspection Report.pdf"
),
H_AssetID.Text,
H_InspectedBy.Text,
H_Location.Text,
H_Date_of_Inspection.Text,
H_NextInspection.Text,
{file: {name: "test.pdf", contentBytes: varPDFex}}
);

it finally worked!!!!

I hope this helps everyone on this issue and works with other file types.

Was this reply helpful? Yes No