Add Attachment with Subgrid | Improve UX

[Anthony_Dob]

Hi Experts,

I have the following use case where I would liked to receive some advice. I have a Model Driven App which allows me to create Trainings. I have a tab Attachments where users can add attachments to the training. Very simple, the attachments has only 3 fields:

• Name
• Attachment file
• Eligible for subsidy (yes/no)

On adding a new attachment. The default behavior is the following flow:

• Create the record
  • Yes/No
  • Name
• Add file to record
  • Attachment file

The behavior I would prefer:

• Create record in 1 step with file attached
  • This way I can make a Business rule to have the name auto populated based on file name.
  • Deletes the purpose of having to first create the attachment record and then adding the file to it.

Edit: I don't want to use a timeline because I want to set attachment files to Yes/No for Subsidy

Best Regards,

Anthony

[EricRegnier · Accepted solution]

Hi @Anthony_Dob,

Unfortunately with out-of-the-box behavior, the record needs to exist before adding a file (assuming you're using the OOB file column type). You can make the Name column optional and hidden on create on the form and still have it auto-populate based on the file name with a business rule, workflow or Power Automate.
Hope this helps!

[Anthony_Dob]

@EricRegnier ,

Yes that is what I currently have. However it would be a lot better if Power Apps would change this on their side so it only requires one step. 

Best Regards,

Anthony

[EricRegnier]

Unfortunately it's not possible as of now. It is more difficult then it seems in the back-end as records and their GUIDs need to be generated to associate file in Azure Blob Storage. Feel free to submit that idea though at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas
Cheers!

[rampprakash · Accepted solution]

Hello @Anthony_Dob,

As per OOB Behavior, without GUID we cannot create/update/or delete any records in Dataverse. So We can do only after Record gets created successfully.

There is No Way to achieve your scinario without Creating a Record.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com