Answered

Need help for File attachment to Share point document library from power apps

(0) Share

Report

Posted on by Ashutosh191

Hi,

need help for File attachment to Share point document library from power apps. I have 2 separate attachment control in power apps to attach the file.

when I'm attaching the file for both the attachment control its working fine, but when attaching the file for one and another one leaving blank is getting an error as Invalid type. Expected string but got Null

using below code

Test_upload.Run(
{
file: {
name: Coalesce(First(Attachment_1.Attachments).Name, " "),
contentBytes: Coalesce(First(Attachment_1.Attachments).Value," ")

},
file_1: {
name: Coalesce(First(Attachment_2.Attachments).Name, " "),
contentBytes: Coalesce(First(Attachment_2.Attachments).Value," ")

}

}
);

@mdevaney please see if you can help on this

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @Ashutosh191
As test it in my side , when i use your code in Power Apps and we do not put the Attachments in one of the control.
Even though we use the Coalesce() function to avoid the null value , the Power Automate still get the null in the "
contentBytes" field.
So controlling null values here in Power Apps doesn't seem to work. This should be your error in Power Automate, and you need to add a Condition verdict in Power Automate that will either prohibit the null value from being executed to the next step, or filter to prevent null from being passed to the next step.

You can also check your Power Automate's run historty to see where the issue is occurring for troubleshooting.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Ashutosh191 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft

Thank you for your reply.
for me the Power Automate flow is not at all triggering if any of the attachment control is keeping as blank and submitting on power apps.

Regards,
Ashutosh

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @Ashutosh191
Thanks for your quick response! Do you mean you configure the power automate trigger condition in your side ?
And as the screenshot , you are using the Power Apps V2 trigger. And i use your code in my Power Apps , there is no error code and it can pass the parameter to the flow.
So , is there any error code in your flow run history ?

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Ashutosh191 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Disabled the option "Formula level error management" in Setting has resolved the issue.

Was this reply helpful? Yes No