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.

Report
All responses (
Answers (