cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kilaj1
Helper III
Helper III

Multiple pages, edit forms and repeating tabels., one attachment Attachment field.

I've been working on a PowerApps for a few months now and I've had quite a few iterations.  Currently I have 17 screens, about 12 repeating tables and about 10 Edit forms in this app.  I used Randy Hayes instructions to get all the forms to work together,  I used  Shane Young's instructions on creating the repeating tables,  April Dunnam's instructions on making the edit tables function work. for the most part this works.  Im now trying to implement attachments and Im running into a wall.

 

I used  Daniel Christian instructions on another App, which worked pretty well; but this was using a single edit form, no repeating table ect.  using Randy's method the attachments don't seem go to the master list.  I tried patching, but this creates a new line item in the SPO list.  I was playing with the idea of patching to a completely different list on submit and pull the ID of my master list, similar to what Shane does for repeating tables.

 

Any other way this can be done?

 

1 ACCEPTED SOLUTION

Accepted Solutions
kilaj1
Helper III
Helper III

Figured it out.  In my Submit button I added a patch after the submit()

 

Patch('Master List Form1',LookUp('Master List Form1',ID = MasterForm.LastSubmit.ID),{},AttachmentsForm.Updates)

 

 

Did the trick, just a bit of display mode clean up now.

 

View solution in original post

5 REPLIES 5
DylanSimons
Resolver III
Resolver III

This sounds really complex for a written post. Could you attach some pictures or examples of what you are describing? What is the expected result?

Sure thing sorry about that.

 

I think the main point of my rambling was the use of a "Master Form" in the app (Randy Hayes instructions), because I have so many Edit forms I needed them to all be in sync for submission since its all going to a single line item in SPO, a SPO "Master List".

kilaj1_0-1623109375304.png

This works by patching the Form.update for each edit form and a global variable to the master list.  This works fine for all other fields except the attachment field.

kilaj1_1-1623109708258.png

Not only do i need to be able to submit an entry into this SPO master list, but I also need to be able to go back and retrieve that data later. Again I've achieved this with all the other data via gallery selection, but the attachments are an issue.

 

When I attempt to patch things as it is, it creates a separate blank line and then the other data gets its own line with all the appropriate info.

 

 

 

kilaj1
Helper III
Helper III

I had a thought on this.  On my Materlist in my app, it has all of my repeating tables "Forall" commands to patch a SPO list.

kilaj1_0-1623165922733.png

I know its possible to add the attachments to a collection, but how would i get it to add to the same line item as the previous form submissions? or do I just send them to another SPO list and use the MasterForm.LastSubmit.ID to track it in the new list?

kilaj1
Helper III
Helper III

Figured it out.  In my Submit button I added a patch after the submit()

 

Patch('Master List Form1',LookUp('Master List Form1',ID = MasterForm.LastSubmit.ID),{},AttachmentsForm.Updates)

 

 

Did the trick, just a bit of display mode clean up now.

 

View solution in original post

thanks for the follow-up!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,020)