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?
