Building flow with approval.

(0) Share

Report

Posted on by Wei Ming Leong

313

Hi thank you for taking time to read this message.

I need to build a approval flow for reimbursement form with attachment of recipient submission from Microsoft form

I have this issue whereby there is this department (TAX) that have 2 managers, so I am not able to use the feature of get manager (from office365 user) as the TAX department staff can select which manager to approve their claim.

So what I did is on the first question I put the list of manager name option of whereby employee have to select their manager even for TAX or other departments.

After they have submit and upload the picture or pdf into the form, it still get store into a sharepoint list.

Can I know what is the best way to do to set up the flow for approval.

I tried to use condition (Switch) to myself with start and wait approval but I have issue as long as I add a 2nd manager it will fail due to the attachment whereby it using attachment expression.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

v-LilyW-msft on at

Like (0)

Report

Hi @WeiMingLeong
Could you please provide the screenshots of the Flow configuration? And what is attachment expression?
I set up a flow you can refer to the screenshots below to see if it helps.
This is my test Form
Flow in details:
Schema:
{
    "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"
        ]
    }
}

When a new response is submitted like below, the manager will receive an approve mail.

Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report

it work greatly.
can i ask in the form there is amount of claim.
how should i set the condition if amount is more than $100, it will required 1st and 2nd approval who is my managing director.
While amount below $100 only need 1st approval.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (0)

Report

Hi @WeiMingLeong
You can add Condition action.
If the amount is greater than 100, when the first approval is completed, use get manager action to get manager’s manager, and then send the second approval email.
If the amount is less than 100, the first approval is completed, the flow ends.
Best Regards.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report

hi @v-LilyW-msft
thank you for your fast reply.
due to i am also using my personal email address to do testing with sharepoint online for allowing external to access.
this caused my search user manager to end up putting my personal email address rather than office email address.
is there a way to make it only get my name with email domain?

update, I found that i can put the full display name.
i will try out to check if i have any more issue and update again.

Thank you very much!

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (0)

Report

Hi @WeiMingLeong
You mentioned that the Condition result is always true, even the amount you put less than 100, therefore I update the following part of the second replay. Please try again.
Best Regards.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report

Hi @v-LilyW-msft ,
thank you for your response. your solution work for the amount also. THank you very much.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report

Hi @v-LilyW-msft & all,
Merry Christmas.
sorry i need to ask 1 more question.
if i need to add in reminder email or post a message in team to the approval.
in which stage do i need to add?

Was this reply helpful? Yes No