Adding Attachment to Multiple Records on Same Table Simultaneously

(0) Share

Report

Posted on by MechEng2013

257

I'm pretty sure I know the answer, but I'm trying desperately to think outside of the box and maybe find a backdoor way to do this.

I have a screen using individual controls (Not in an EditForm) that patches data to new records all at one time for my Purchasing department to enter cost changes from one supplier on multiple items at once. They want to be able to add the quote file for all of those items at one time.

Everything works as it should and now they want the attachment functionality. I am finding that patching attachments is "Not Possible", that the datatype returns as "Table". Surely there is a way to add an attachment to a record's attachments field outside of a form?

If not, is there something creative I can do by adding a form on this page that follows up the patch function with an update to that record? Can I store the attachment temporarily in a collection or another attachment box perhaps in order to facilitate this?
Any thoughts or comments welcomed!
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @MechEng2013 ,

It can be done with Power Automate - you can get the ID of the new record - it would look something like this

UpdateContext( { varID: Patch( YourPatchHere ).ID } ); YourFlowName.Run( varID, { file: { contentBytes: Last(AttachmentControlName.Attachments).Value, name: Last(AttachmentControlName.Attachments).name } } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MechEng2013 257 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz thanks for the reply!

Here is what I have so far:

UpdateContext(
{
varID:
Patch('Cost Changes',
Defaults('Cost Changes'),
{
Article: DataCardValue319_17.Selected,
}
).'Cost Change'
}
);
CostChangeMultiAttach.Run( // flow to attach file to multiple records
Value(varID),
{
file:
{
contentBytes: Last(CostMultiAttach.Attachments).Value,
name: Last(CostMultiAttach.Attachments).Name
}
}
);

I'm in Dataverse, and I think you're code was for Sharepoint, so for the flow run command it was expecting a number value and returning a GUID, so I added Value() function there.

I'm getting no errors now, but the flow did not run at all. Checking Run History shows no runs.

I did verify that varID is getting populated in the updatecontext function,

Is there anything else I can share?
Thank you!!!!

Was this reply helpful? Yes No
WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MechEng2013 ,

Always a good idea to state your data source in your initial post - I mistakenly assumed SharePoint. I do not use Dataverse (I am SharePoint only), so am not the best person to help you. I will tag my colleague @timl to see if he can assist.

Was this reply helpful? Yes No
Suggested answer

Mehmet_Powerapps 26 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi MechEng2013 ,

i think, i solved your problem. In my solution i have a combobox to select the records (here i select the records by title).

The formula i wrote in the OnSelect property of the Update button is as follows

ForAll( ComboboxTitel.SelectedItems, Patch( MySharePointList, { Titel: ThisRecord.Value // This part is optional. If there are any areas we want to update, we can add them here. // I added the Titel field as an example. } ); Patch( MySharePointList, LookUp(MySharePointList,Titel=ThisRecord.Value), Form1.Updates ) )

Tip of the solution is that "We write two times patch function in the Forall".

You can find the more details about my solution at my Meidum account. Just search this term on google.

"Save a file as an attachment for multiple records in Power Apps".

Was this reply helpful? Yes No