Creating an approval process and update sharepoint list

(0) Share

Report

Posted on by jamienorris

Hi,

Thank you in advance for any help provided, I am just starting out with flow so your patience is appreciated.

I am trying to create a flow to (in this order)

Collect pdf files (using forms)

Create entry in "attachmentslib" list sharepoint (include pdf's)

Create entry in "BFTA7 Form" list sharepoint

Approval requested to DL address (and attachments pdfs included)

Everything above is fine, now comes the issue

I need to get different attachments into the "BFTA7 Form" sharepoint list but into the same entry that was created previously (basically update that field with the new attachments). I cant get this to work it just creates a new entry everytime.

To input the 2nd lot of attachment I was using a 2nd different MS Form

Using a field on that form to match using Condition the SharePoint ID

Can someone advise what I'm doing wrong. Thanks (sorry if I have explained it badly)

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

jamienorris 10 on at

Like (0)

Report

It always flows into no - into send an email and apply to each 5

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @jamienorris,

There are some contradictions in your description, which I don't quite understand. Such as:

"I cant get this to work it just creates a new entry every time." and "It always flows into no - into send an email and apply to each 5"

I can see the no branch is to update item, not create item, so I don't understand which situation is you are facing one.

I assume that the condition always go to no branch, condition not met is caused by the question of MS Form not equals ID of SharePoint item, you could create a compose action before the condition 2 action, input dynamic content of MS Form and SharePoint ID into it to check if they are same.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
jamienorris 10 on at

Like (0)

Report

I have amended the below post. I hope this is clearer:

Hi,
Thank you in advance for any help provided, I am just starting out with flow so your patience is appreciated.
I am trying to create a flow to (in this order):
Collect pdf files and some answers (using group form)
Create entry in "Attachments Library" list sharepoint (include pdf's)
Create entry in "BFTA7 Form" list sharepoint (no attachments required because they will be included in the email later)
Parse JSON
{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": "string"
            },
            "link": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

Gather all the pdf attachments
Attachment them to an email for an approval process to DL address (and attachments pdfs included)
If rejected – send email – update spreadsheet on BFTA7 form
If Approved – the user is asked to submit another MS form “CDU Form” with different attachments and then click approve (I used the approval process instead of email with options because I wanted the approver to be recorded)
I want to now match the attachments and answers from “CDU forms” into the BFTA7 list sharepoint to update and say approved and add attachments
It doesn’t work and adds a new entry onto the list
I tried using the ID of the item to which is provided to the user in the email to add into the 2nd MS form to link the 2 together without success.
Issue 1: Issue updating that BFTA7 sharepoint list with newest attachments and saying “approved”
Issue 2: Attachments in the email appear with correct name – but when I click to open them it says “adobe acrobat reader could not open ‘XXXXX.pdf’ because it is either not a supported file type or because the file has been damaged.
I was wondering do I need 2 different flows to make this work.
Does anyone have the best way to achieve this? Maybe I’m going about it all wrong

Was this reply helpful? Yes No
jamienorris 10 on at

Like (0)

Report

Was this reply helpful? Yes No
jamienorris 10 on at

Like (0)

Report

@v-litu-msft Thanks for your response. I hope the messages below will help explain better

Was this reply helpful? Yes No