cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisS81
Helper III
Helper III

SharePoint Create Item Action

Good Morning,

 

I'm running into an issue that I cannot solve. I have users completing a MS Forms form and their responses are being logged in a SharePoint List via Power Automate. I'm getting an error on the SharePoint "Create an item" action. The error message is below:

 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_13' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

 

The problem is that #1 I do not have a field column called "field_13" in my SharePoint List and none of the field in my List are required, except for the Title field of course. Any ideas on why this mystery field is causing this error?

 

Any help is greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
v-liwei-msft
Community Support
Community Support

Hi @ChrisS81 

 

You can use the if function on the date field to give the field a null value if the date is empty.

if(empty(outputs('Get_response_details')?['body/xxxxxxxxxx']),null,outputs('Get_response_details')?['body/xxxxxxxxxx'])

In this way, flow will not report an error.

 

Best Regards,

Levi

View solution in original post

4 REPLIES 4
abm
Most Valuable Professional
Most Valuable Professional

Hi @ChrisS81 

 

 Looks like there is a mapping issue here. Are you collecting any date field from the form response? Is that non-mandatory field? Looks like its blank. To able to give you an exact answer could you please post  a screenshot of your flow?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@abm, yes I am collecting a date field from the form response. The date fields are no mandatory. After a little more investigating it looks as if I receive that error message for any date field where I have not selected a date. When I remove the MS Form dynamic content for the date fields I do not receive the error. But the moment I add the dynamic content back to the date fields and submit the form without entering a date field, I get the error.

 

 

 

 

v-liwei-msft
Community Support
Community Support

Hi @ChrisS81 

 

You can use the if function on the date field to give the field a null value if the date is empty.

if(empty(outputs('Get_response_details')?['body/xxxxxxxxxx']),null,outputs('Get_response_details')?['body/xxxxxxxxxx'])

In this way, flow will not report an error.

 

Best Regards,

Levi

ChrisS81
Helper III
Helper III

@v-liwei-msft this solved my issue. Thank you so much!

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Back to Basics Tuesday Tip #3: Contributing to the Community

  This is the third post in our series dedicated to helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we feature new content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!   This week's topic: Contributing to the Community Ever wondered how to quickly find answers to your questions with so many different forums and areas to explore? The best way is to SEARCH for answers! This handy article explains exactly how to search and get the answers you're looking for!  Using Search to Find Answers and Unanswered Topics - Power Apps , Power Automate, Power Virtual Agents, Power Pages.     Make sure you don't miss a thing in the community, whether it's the latest News & Announcements, answers to your questions, or topics you are interested in. SUBSCRIBE to notifications to stay on top of what's happening and what matters most to you. Find out how here: Subscriptions and Notifications: Power Apps, Power Automate,  Power Virtual Agents , Power Pages.     You want your posts to look good, and we want to make it easy for you to format, alter, and adjust your posts before they go live! The Article Body Toolbar is the handiest tool in your toolbox, allowing you to format your posts in a variety of ways--making it easier to share your information. Change the alignment of your text, add bulleted or numbered lists, insert tables or code samples, express yourself with emoticons, add images, etc. Read more here: How to Use the Toolbar: Power Apps, Power Automate, Power Virtual Agents, Power Pages.With these handy tips, you'll find what you're looking for, ask some great questions, and format your posts perfectly! Check back here next Tuesday for the next iteration of our "Back to Basics" series. #TuesdayTips

We Need Your Voice: Write for the Community Blog!

  We want YOU to be part of the community blog! Sharing your knowledge of Power Platform is an essential part of our community! Here's why:   It helps create a vibrant and dynamic community of makers who can learn from each other’s experiences and insights.It provides a platform for collaboration and innovation, where members can share their ideas and work together to develop new solutions.It helps promote Power Platform by showcasing its capabilities and real-world applications.It helps build trust and credibility in the community because you are providing valuable information and resources your fellow community members can use to improve their skills and knowledge. By sharing your knowledge of Power Platform in the community blog, you help us create a more engaged and informed community, better equipped to tackle complex challenges. Share your knowledge on the blog and help us help even more people discover how to use Power Automate! Just follow this link: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/bg-p/PowerAppsBlog   Look for the button below, and let us know you're interested. We can't wait to connect with you and help you get started. Thanks for being part of our incredible community--and thanks for becoming part of the community blog!    

October 2023: Celebrating New User Groups & Events to Check Out!

It's time for our monthly celebration of new user groups that recently joined our community, along with events happening nearby--or even virtually!  There's so much going on our community, it's a great time to pause and celebrate what is happening in our user groups and in our community this October!   PLEASE WELCOME THESE NEW USER GROUPS: Biz Apps Community User Group - Power Platform Community (microsoft.com)  This user group is dedicated for any community members of all skill levels to learn how to get the most out of their community experience. East Michigan Power Platform User Group - Power Platform Community (microsoft.com)  This is the start of a new community covering eastern Michigan, built around the Power Platform. Biz Apps Community User Group  This user group is dedicated for all community members of all skill levels to learn how to get the most out of their community experience.   EVENTS TO CHECK OUT: IN-PERSON AND ONLINE In-Person: September 2023 Hybrid Philadelphia Dynamics 365 & Power Platform User Group Meet  Dynamics 365 and Power Platform Physical Meetup  Hyderabad Power Platform User Group Meetup - Sept 2023 (In-Person)  Manchester September 2023 In Person Meeting  Virtual: Everything Dataverse, Do you know that Dataverse is more than just a Database! POWER PLATFORM MONTHLY DIGEST- SEPTEMBER Baltic Summit 2023 PL-900 Power Platform Fundamentals Training HR and L&D transformation through Power Platform Dynamics 365 Marketing Experience User Groups - Use Cases and Networking Power Platform and Dual Write from Dynamics 365 F&O Perspective ANZ D365 FinOps Team September 2023 meetup 

Users online (4,236)