Answered

Flow to populate data from Form to Sharepoint List

(0) Share

Report

Posted on by MerlinT

I am very new to this - this is only my second flow and I am sure there is a very easy answer. It is a very simple flow with a very simple form / list. I have looked up a lot of the forums looking for a solution - however most of the responses are above me.

I am trying to populate a Sharepoint list from data within a Form. The flow works if all fields are completed but if either of these 2 fields are left blank, it fails. I expect the majority of responses will leave these 2 fields blank which is fine. I get this error message which I believe relates to the empty fields.

Would really appreciate any suggestions.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @MerlinT ,
please refer to the following Solved Post:

https://powerusers.microsoft.com/t5/Building-Flows/Create-Item-fails-user-field-left-blank/td-p/1384373

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
MerlinT 42 on at

Like (0)

Report
Copy link

Link copied!

Hi Marco

Thanks for your response. However I still don't seem to be able to get it to work. This is my actual flow

When I try and add the Initialize Variable before Create Item, I get an error saying it can only be added at the top level.
What am I missing?
Cheers
Merlin

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @MerlinT ,
please initialize the Variable at the beginning of your flow.

Then, in the below steps you can set it based on the Condition.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
MerlinT 42 on at

Like (1)

Report
Copy link

Link copied!

Hi Marco

Thank you so much for your time. After spending way too many hours on this, I was able to fix it by simply changing the column format in my sharepoint list.
Thank you again for trying to assist.
Kind regards

Was this reply helpful? Yes No
Verified answer

MerlinT 42 on at

Like (0)

Report
Copy link

Link copied!

Hi Marco

Thank you so much for your time. After spending way too many hours on this, I was able to fix it by simply changing the column format in my sharepoint list.
Thank you again for trying to assist.
Kind regards

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @MerlinT ,
please mark your post as Solved, so that all the Community is aware of.

BR,
Marco

Was this reply helpful? Yes No