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

[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

[v-yueyun-msft · Accepted solution]

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

[Ashutosh191]

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

[v-yueyun-msft]

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

[Ashutosh191]

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