web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Vacation Approval Flow
Power Automate
Unanswered

Vacation Approval Flow

(0) ShareShare
ReportReport
Posted on by

Hello,

newbie here!

I created a flow for our department to use to submit their leave request for approval. The flow is working fine:

1. Someone completes the Microsoft form

2. It starts the approval email process and is sent to the requester’s manager

3. Once approved or rejected, an email is sent to the requester and myself (I keep track off all records for payroll purposes)

4. It is added to the leave request calendar


This is where the issue is. Unless all of the fields in the form are filled out, the flow fails to add the information into the Sharepoint list. The form is set up so people can submit for a full pay period (10 days) and different leave types (vacation, sick, jury duty, bereavement, etc.) for each day if needed. Ideally, I would like to avoid asking my coworkers to fill in the field with "N/A" or "1/1/2023" for dates they are not requesting off. 

Is there an expression or condition I can add to the flow that will allow the data from the form to upload to Sharepoint? What is the placement of the condition?

 

FYI: none of the Sharepoint columns are a required field. 


‘thanks in advance. This has been kicking my butt and I know it has to be a simple solution. 

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Ojoi ,

     

    Do you mean when some fields in the form is empty, the flow will fail to create item in SharePoint list? Could you please share some screenshots of the error and your flow steps?

     

    Anyways, you can try and use expressions for every column input fields to check if the value from form is empty and then use null value in the field to create item.

    if(empty(FieldDynamicContent),null,FieldDynamicContent)

    vjefferni_0-1673322511522.png

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 976

#2
Valantis Profile Picture

Valantis 863

#3
Haque Profile Picture

Haque 547

Last 30 days Overall leaderboard