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?
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:
These are just workarounds though. How do I just focus on the fields I care to update?
Thanks for the tip. I'll give it a try soon.
When I have some news I'll post an reply.
Kind regards.
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
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional