Answered

Optional E-mail in Instant 'For a selected file' in OneDrive for Business

(0) Share

Report

Posted on by TimHNZ

Hello,

Trying to create an approval flow for an Excel budget in OneDrive for Business. To run the approval a user inserts a PI (which is compulsory) and one or more HOD e-mails (which is optional).

For a Selected File.png

If a user has inserted an HOD e-mail(s) the approval process goes to them first and runs an 'everyone must approve' approval and then if they all approve goes to the PI. If they don't insert any HOD e-mails, it goes straight to the PI for approval.

So basically I want a condition which checks if there are any HOD e-mails. Have tried:

triggerbody()?['HODs'] is equal to null

triggerbody()?['HODs'] is equal to 0

length(triggerbody()?['HODs']) is greater than 0

plus several others, and I can't get any of them to work.

I'm sure it's an easy thing to do!

Thanks,

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@TimHNZ
Is this a Manual flow? And the fields are Inputs to it?
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TimHNZ ,

What is the type of the HOD column and the PI column? Are they person type column allow multiple selections?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TimHNZ 10 on at

Like
a
(0)

Report
Copy link

Link copied!

By Manual flow do you mean Instant? i.e. it's run by right clicking on a file in OneDrive and selecting the flow from the Automate menu.

The fields come from the 'For a selected file' connector:

PI is set to required, HODs set to optional. Both can accept multiple e-mails.
TimHNZ 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure what you mean by columns? This isn't from a Sharepoint table.

It's from the 'For a selected file' connector/trigger in OneDrive for business.
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TimHNZ ，

Please refer to screenshot below to create the flow:

empty(outputs('Compose'))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TimHNZ 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Alice, worked perfectly!