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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,751)