cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fricandel
Frequent Visitor

Update Sharepoint Related List Mandatory Fields

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?

1 ACCEPTED SOLUTION

Accepted Solutions
gamoraes
Memorable Member
Memorable Member

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


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

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

3 REPLIES 3
gamoraes
Memorable Member
Memorable Member

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


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

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

@gamoraes

 

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

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

 

Kind regards.

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,568)