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?

All responses (4)

Answers (2)

MattB1984 2 on at

Like (0)

Report

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

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.
DGS 114 on at

Like (0)

Report

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

How do you do this?
Verified answer

Kepcla on at

Like (0)

Report

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

Long road, but it works!
Verified answer

v-xiaochen-msft on at

Like (0)

Report

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

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