Answered

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

(0) Share

Report

Posted on by kilaj1

257

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?

All responses (5)

Answers (1)

DylanSimons 326 on at

Like (0)

Report

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

thanks for the follow-up!
Verified answer

kilaj1 257 on at

Like (1)

Report

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

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.
kilaj1 257 on at

Like (0)

Report

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

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.
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 257 on at

Like (0)

Report

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

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".
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.
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.
DylanSimons 326 on at

Like (0)

Report

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

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?