Unanswered

Help creating an only move on when a column contains information rule in flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

A little context,

I have a flow set up in a library for document approval. When the users upload the document they are required to assign 2 people to the approval process (this can be from a list of 100+ people) which are currently separated into two columns. Below highlighted in orange

Unlike lists, I am unable to make it so the information in these columns has to be supplied prior to the upload, which means the trigger of "When a file is created" runs immediately after upload, it fails when it tries to find the email information that would be supplied in these 2 sections.

Here’s the flow as it is:

I have tried adding a "do until" action (see below) between the Upload and the first Update but because of the multiple verities of contents it never seems to work, this also needs to cycle for 5 working days to give them ample time to assign the right people.

There is nothing in the value date in this screenshot as I haven’t found anything that works. I essentially want it so say "Check the director column for information, when information has been supplied, move to the next step"

I am probably being stupid but can anyone help?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to create a flow to move on to the next action only when two specific columns contain value?

If yes, please try to add a Condition with the following code:

@and(not(equals(triggerBody()?['Approver'], 'null')),not(equals(triggerBody()?['FinancialApprover'],'null')))

I have created a simple flow to test this issue and it works fine. Please try it on your side.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Mabel,

Thank you for your response.

Yes, so the user will upload a document to the library, then they will select the two approvers. This can be done in the first minuet or a week later so the process needs to hold until that information is input, then once it has both pieces it can continue the flow.

I have given the code a test and unfortunately it seems to just run through the process without any action required. (i did move the delay down for testing purposes) I also tried it amending the code a little to fit the column details and it did the same thing.

It gets to the condition and accepts it before anything is updated in the document properties.

It would be nice to have a check for information condition that auto loops until it’s provided.

As a temp fix i am running a delay of 24hrs with a notification going out to the submitter that they have to input this information within the time frame or it will require resubmission. But the fact is has to delay everything even if they input the information in a few minutes isn’t the best situation.

Many thanks

Was this reply helpful? Yes No