Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Flow to populate data ...
Power Automate - Building Flows
Answered

Flow to populate data from Form to Sharepoint List

(0) ShareShare
ReportReport
Posted on by MerlinT 42

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.

MerlinT_1-1659575561912.png

 

MerlinT_0-1659575482295.png

Would really appreciate any suggestions. 

Thank you

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,822 on at
    Re: Flow to populate data from Form to Sharepoint List

    Hello @MerlinT ,

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

     

    BR,

    Marco

  • Verified answer
    MerlinT Profile Picture
    MerlinT 42 on at
    Re: Flow to populate data from Form to Sharepoint List

    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

  • MerlinT Profile Picture
    MerlinT 42 on at
    Re: Flow to populate data from Form to Sharepoint List

    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

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,822 on at
    Re: Flow to populate data from Form to Sharepoint List

    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

  • MerlinT Profile Picture
    MerlinT 42 on at
    Re: Flow to populate data from Form to Sharepoint List

    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

    MerlinT_2-1659657502105.png

     

     

    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

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,822 on at
    Re: Flow to populate data from Form to Sharepoint List

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans