Answered

Approval Workflow

(2) Share

Report

Posted on by DY-10041741-0

Hi Everyone,

I'm using power apps to build a POREQ approval workflow. I'm pretty happy with it but I'm running into problems leveraging the Power Automate Approval.

Here is where I'm struggling:

1) I'm not sure how to attach multiple files to the approval. Prior to triggering this workflow, I have another workflow to upload the documents to a document library. I'm not sure how to link this document to the approval workflow to bring in the attachments because the ID.

It seems like it would be pretty easy to do

https://www.youtube.com/watch?v=FZiNBP8aIFw

However, my issue is that my attachments are in a document library and not a list and I'm not sure what the ID will be because it's being created in the flow triggered before. However, I will be able to tag it with like POREQ0001.

2) The details of the approval workflow should have a table with the header and line level details looking like this.

VENDOR: Amazon

Total Price: 10,000

Item: Price Qty Total

Glue 1 1 1
Tape 1 1 9,999

I can do the top part. I'm not sure how to take the table and add it to my approval workflow.

I'm sure this isn't hard but it's difficult for me. Any help is appreciated!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @DY-10041741-0,

I explained both things in articles some time ago:

1. the attachments to an approval task: https://tomriha.com/assign-approval-task-with-multiple-0-n-attachments-in-power-automate/

2. tables in approval task: https://tomriha.com/show-approval-history-table-in-approvals-tasks-power-automate/

----------------------------------------------------------------------------------
Did the answer solve your problem? Please click "Does this answer your question" and give it a like to help others in the community find the solution too!

You can find more of my solution on the blog: https://tomriha.com

Was this reply helpful? Yes No
DY-10041741-0 8 on at

Like (0)

Report

Hi Tom,

Great links! I have a few questions for you.

Multiple File Attachments: Here are my challenges using your method. The first issue is that the get attachments is for files saved in a sharepoint list. My documents are being saved in a document library. The second issue is that I think you use the ID to determine what attachments to use. I'm not going to know what the ID is for the document library as the items are being created right before I grab it.

NOTE: This is the first time I have ever seen anyone upload documents to a sharepoint list. It seems like the best solution is to capture the data in Power Apps and create the record in using Power Automate (which I did) then attach the files to that list using Power Automate (which I don't know how to do) then I can follow your process to attach them to my approval.

I'll look into how to do that but if anyone has any ideas that would be helpful.

Table Details: I think this process makes sense and I can do it. I just need to figure out how to get that information into Power Automate from Power Apps. Thanks a lot!

Was this reply helpful? Yes No
DY-10041741-0 8 on at

Like (0)

Report

Hi. I think I'm pretty close. I just need a little more help to get this over the finish line. Okay, so I updated my flow.

1. PowerApps - This gives me the information in my flow.

2. Initialize Variable - This is just formatting the approval stuff.

3. Create File - This takes the uploads and saves it into the document library.

4. Update File Property - This takes the newly created file and adds in some metadata.

Here is where I think I'm struggling

5. Initialize Variable 2 - This is where I create all attachments section. Name: AllAttachments Type: Array

6. Get File Content (I don't really understand what this does) - I go to my document library and I grab the identifier.

7. Apply to each - using the identifier

8. Append to array variable: Name: All Attachments, Value Section: {Name: Display name, Content: Content}

9. Create Item - This is creating the item in the sharepoint list.

10. Start and wait for approval. Attachments = All Attachments

Was this reply helpful? Yes No
DY-10041741-0 8 on at

Like (0)

Report

@tom_riha, I think I have it. I followed your instructions. Unfortunately, since my item is using a document library I'm running into a small issue. The files don't have the proper attachments in them.

This is confusing to me because the content does have the extension on it.

Do you have any suggestions as to why I'm having this issue?

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

@DY-10041741-0, if it's not file attachments then use the 'Get files (properties only)' with some filter to get the related files and the it's the same. Just query a library instead of attachments. You can search the files by file name or some other column in the document library - I guess you must have the files connected to items using some ID column.

Was this reply helpful? Yes No