Storing multiple File attachment in Dataverse table using Power Automate flow

(0) Share

Report

Posted on by Thinzar

Hello,

The flow I would like to use is as follows.

Firstly, I would like to add each file attachment submitted, to the a collection and gather for a while.

Then, all the file attachments in the collection will be passed to the power automate flow by using ForAll in order to store in certain Dataverse table.

Thus, could you please help me with saving the file attachment to the collection ? Still, I do not have idea how to use the formula.

The sample scenario is as follows.

If(

IsBlank(combo_budgetCodeRH_1.Selected.BudgetCodeID) || IsBlank(txt_MaterialPA.Text) || IsBlank(txt_FileattachPA.Text) || IsBlank(txt_PurposeRH_1.Text) || IsBlank(txt_ReqAmountRH_1.Text),

Notify(

"Please fill all the required inputs",

NotificationType.Warning

Collect(

RentHallGal,

{

Location: txt_MaterialPA.Text,

TotalDays: txt_FileattachPA.Text,

Purpose: txt_PurposeRH_1.Text,

ReqAmount: txt_ReqAmountRH_1.Text,

BudgetCode: combo_budgetCodeRH_1.Selected.BudgetCodeID

}

)

This is the screen I am creating

Multiple inputs will be used, in addition to the file upload.

Thus, form could not be used.

PS. The code is just adding data to the collection and does not include for adding file attachments. I would like to know how to modify the code and the new code for adding file attachments.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @Thinzar

Can you try to use this expression in your Attachment control for three fields:

ClearCollect(colAttaches,Self.Attachments)

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Thinzar on at

Like (0)

Report
Copy link

Link copied!

Hello, @v-yueyun-msft ,
Thanks with your suggestion.
I have inserted the formula you have provided.
What I would like to prepare is as follows.
I would like to collect the file in a certain collection separately with its file attachment and its name.
Then, the collected multiple files from the collection are to be passed to a certain power automate flow. To do so, I have found out that the file needs to be in acceptable format like JSON. So before passing the files, I would like to change its format into JSON also.

Could you please give me some idea of this. I have provided with the formula and screenshot also.

Collect(
fileUploadCol,
{
FileName: {file:{contentBytes:Last(fileQuotation.Attachments).Name}},
FileAttachment: {file:{contentBytes:Last(fileQuotation.Attachments).Value}}
}
)

The added file appears as table in the collection as follows

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

Like (0)

Report
Copy link

Link copied!

Hi , @Thinzar

Thanks for your response! Do you mean you want to get the Table like this:

If this , you can try to use this expression:

Collect(fileUploadCol,ForAll( FileUpload.Attachments ,{contentBytes:Value ,name:Name}) )

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Thinzar on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply, @v-yueyun-msft

Whether table or not, I would like to collect the uploaded file from users in somewhere like collection, and then converted to the JSON format so that I could further proceed in transferring those files to the power automate flows, in order to store them in Dataverse table.

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

Like (0)

Report
Copy link

Link copied!

Hi , @Thinzar

Thanks for your response! Do you mean you want to convert your collection to Json Onject.

If this you can try to use this expression:

Set(jsondata , JSON(fileUploadCol , JSONFormat.IncludeBinaryData) )

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No