You’re offline. This is a read only version of the page.
Announcements
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.
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.
Share
Report
All responses (
Answers (
if(empty(FieldDynamicContent),null,FieldDynamicContent)
Best regards,
525
