Flow Requirements: I need the flow to read an excel table and if a column value is "Yes" then run a flow that will raise an Item on a Sharepoint List and then update the row on the table. The Sharepoint list uses a Lookup column to another Sharepoint list and I need the Excel Value to find this lookup value.
Issues I need help with:
- I need to pull the Items from the Tool Manager so that I can find the tool and use its value later in the flow. How can I filter the Get items to the Excel Tool Number Value only? So If I have 1 item that needs servicing, it will only pull the Tool Information for that 1 item.
- How doI populate the Sharepoint entry parameter with the Excel Tool number? I have been experiencing Interger 64 errors.
Excel Table:
Sharepoint Lists:
Flow Diagram:
UTC Now:
List Rows Filter:
Each Excel Row: The body will be from the Get Tool Manager Items (Filtered)
Create Item: Creates in WTRF Database
Update Excel Row:
629
Share
Report
All responses (
Answers (