Oct 01 2020 06:55 AM
Dear Everyone,
I have created a sharepoint list. I used forms to enter my data and then referenced the forms in the flow to display the content in sharepoint list.
Initially i was able to get the data entered using forms and displayed in the sharepoint list. Unfortunately from last week, when i execute my flow, the data entered using the forms is not displayed in the sharepoint list. Instead i get a row created but the data in the fields are missing.
please note the error in the list is shown as "required info"
could you help me out?
Best Regards
Vj
Oct 01 2020 07:02 AM
Hi Everyone,
Refer to the flow error message snip attached for your references.
hope to get your support.
Br
Vj
Oct 01 2020 09:26 AM
@Vj2020 the error is with the Create item action as it completes but doesn't look as if you are adding the responses from the form into the relevant columns which is why the error is showing that it found a null value. Could you give a screenshot of this action the flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Oct 01 2020 10:36 AM
Oct 01 2020 10:45 AM
@Vj2020 it's not the error message I need to see, I know what that says and what it means. What I want to see is a screenshot of the Create item action as I think that is where you might have made an error.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Oct 01 2020 11:21 PM
enclosed the flow details from the create item. Hope it helps to clarify your question.
Oct 02 2020 03:27 AM
Solution@Vj2020 the error message related to the Title column being null. I can't see the Title column in your Create item action. I assume you renamed it to one of the other columns shown in the image., e.g Activity. But you need to make sure that the if you have required columns in your list that the form answers for those questions are also mandatory. It looks as though the form was submitted without that filed in the form having an answer in it.
Rob
Los Gallardos
Microsoft Power Automate Community Super Use
Oct 02 2020 05:20 AM
@RobElliott I have created the new form and made sure all the columns in forms and share point are listed.
What i have done is, i have used the existing ID column in my share point list so that i can have unique ID for each item created.
I used the forms to create a new list and display in the share point.
Is this might be the reason ?
Best Regards,
Vj
Oct 23 2020 01:38 AM
@RobElliott Thank yo very much and apologies for my late response.
I took a bit of time, but created a new list and followed your advise it worked well.
Appreciate your support.
Oct 02 2020 03:27 AM
Solution@Vj2020 the error message related to the Title column being null. I can't see the Title column in your Create item action. I assume you renamed it to one of the other columns shown in the image., e.g Activity. But you need to make sure that the if you have required columns in your list that the form answers for those questions are also mandatory. It looks as though the form was submitted without that filed in the form having an answer in it.
Rob
Los Gallardos
Microsoft Power Automate Community Super Use