You’re offline. This is a read only version of the page.
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?
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
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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (