Unanswered

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

I have the same question (0)

All responses (6)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
TimHNZ 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
TimHNZ 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
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.

Was this reply helpful? Yes No
TimHNZ 10 on at

Like (0)

Report

Thanks Alice, worked perfectly!

Was this reply helpful? Yes No