I have a Equipment list that includes Bldg No, Asset No, Date of Last Inspection, and Inspection Status. The list unique identifier is the Bldg No. The Bldg No may appear several times on the list, based on the number of pieces of equipment in the building. The data from several inspection forms, by way of multiple workflows, update the Date of Last Inspection. As long as there is only one Asset in a building (meaning one Bldg No line item), all workflows have been updating Date of Last Inspection as intended. My question, will the same workflow change multiple dates at the same building, where several assets are located in the building? Example: One Bldg with a furnace, elevator, hot water heater (or, 3 Assets). Will the upload of one inspection form, update the dates of all the assets, where the form is based on the Bldg No (to which the assets associated)?
You can update multiple items using a loop in sharepoint 2013 workflow this is the latest feature given in 2013 but not in SharePoint 2010 workflow
you can query the Items by Bldg No. using rest API in the workflow. You can see how to call REST API in the below link in workflow
You can use loop in workflow and update the list item based on condition you can see the below screenshot for giving you awareness on the workflow loop and service call. you can also keep the conditions in loop.
Please check and let me know if you have any queries.