Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Update Sharepoint Related List Mandatory Fields

(0) ShareShare
ReportReport
Posted on by 4

Flow.jpg

I have connected two SharePoint lists in SharePoint online. I have also connected a list with a Sharepoint Library. The reason why I have done this is because PowerApp doesn't support SharePoint Libraries as a data source. I have created several SharePoint Designer workflows to replicate only the wanted records in to the lists, now I am trying to replace my SharePoint Designer Workflows with Microsoft Flow.

 

In a nuttshell:

When an entry is created in the SharePoint List/Library a SharePoint Designer Workflow creates an entry in the List for PowerApp. This entry contains a status field. When this status field is changed into "Done" by using a PowerApp, a SharePoint Designer workflow changes the status in the underlying SharePoint list and removes the entry from the List for PowerApp.

 

My issue:

When I create a Microsoft Flow to replace the SharePoint Designer Workflows, I am able to select the correct Flow Template to update another list. I am also able to select the underlying List. But when I select this list, it shows my all the field of the list (of course), but it also marks the mandatory fields. I do not want to update these mandatory field, but Microsoft Flow makes them mandatory as well. I don't understand why, because it is not a new entry. And when I update a field of an entry, the mandatory field should allready contain information.

 

My question:

How can I work arround the mandatory fields of the underlying list and just update one of the other fields?

  • JeromeSmith Profile Picture
    4 on at
    Re: Update Sharepoint Related List Mandatory Fields

    I have the same question: how can I target the fields I want to update instead of filling in the required fields?

    I want to skip the required fields because I have 10+ parallel tasks and they all 5+ required fields in them.

    My workarounds:

    1. go to the list in SharePoint and mark all those felds as optional. update the flow. go back to the list and mark those fields as required.
    2. insert a get-items step right before the update fields step. update the required fields with the same information.

    These are just workarounds though. How do I just focus on the fields I care to update?

  • Fricandel Profile Picture
    4 on at
    Re: Update Sharepoint Related List Mandatory Fields

    @gamoraes

     

    Thanks for the tip. I'll give it a try soon.

    When I have some news I'll post an reply.

     

    Kind regards.

  • Verified answer
    gamoraes Profile Picture
    1,040 on at
    Re: Update Sharepoint Related List Mandatory Fields

    Hi @Fricandel


    If the list you have to update are the same that have triggered the flow, just put the same fields(trigger) at the mandatory field(action), if not you can use the 'Get Item' action to get this item and do the same thing, put the same fields.

     

    Whit this you will 'update to the same'. Make sense?

     

    Hope have Helped,

     

    Gustavo Moraes

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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow