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:

Business Process Flows

All responses (6)

Answers (1)

TimHNZ 10 on at

Like (0)

Report

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

Thanks Alice, worked perfectly!
Verified answer

v-alzhan-msft on at

Like (0)

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

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 (0)

Report

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

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.
TimHNZ 10 on at

Like (0)

Report

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

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.
v-alzhan-msft on at

Like (0)

Report

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

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.
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

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

@TimHNZ
Is this a Manual flow? And the fields are Inputs to it?