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.
