Do you want to get items that Date is equal to Last day and Transportador contains “Your car” from List 1 to the second list if they have the same Cliente?
I have made the following test according to your description.
Crete two SharePoint lists, List11 and List22 which contains the needed columns you mentioned.
Then set up the flow likes below.
In Get items action, input the following code in Filter query to return items that date equals to Last day:
Date eq ‘addDays(utcnow(),-1,'yyyy-MM-dd')’
Add a Condition with this code in Advanced mode to check if the Transportador contains “Your Car”:
@contains(items('Apply_to_each')?['Transportador']?['Value'], 'Your Car')
Under If yes branch, Get items 2 to get items in List 22.
Add Condition2 to check if the two lists have the same Cliente:
Under if yes branch, add action Update item to update the corresponding value from List11 to List 22. In this action, please select dynamic content ID, Title, Cliente from Get items2 for the Id, Title, Cliente fields separately, and select other fields from the Get items action.
Please take it for a reference and try it on your side.
Thanks for your reply!
This is what I have in the first list:
"Data" have DateTime format (different from yours);
when "TRANSPORTADOR" have "VOSSO CARRO" stops the flow and if "CATEGORIA" is "CLIENTE" copy item to the second list. If is "FORNECEDOR" stops.
I tried with your suggestion but without success 😞
I will be thankful if you could help with this situation.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.