Submitted on08-20-201907:52 AMSubmitted byheylookitsmeon08-20-201907:52 AM
Users need an easy way to use the equivalent of Excel's Index Match Formula to retrieve data from a Sharepoint List. I understand that Get Items with ODATA is supposed to accomplish this, however, I am an intermediate user and I have already spent 6 hours trying to research and use this function and it still does not work. If users could select an action called Index Match From List, then choose Site and List. 3 other fields called 1. Column Value/String Lookup, 2. Item or String Match, 3. Matching StringColumn Users could easily match intersecting field data to pull the data needed into their workflow. For me for instance, I have a list of buyers with three columns BuyerEmail, MgrEmail, SiteMgrEmail and when using the start and wait for an approval workflow I could easily match the BuyerEmail (who triggered the workflow) to grab the Manger and Site Manager emails from the buyersEmail matching row data. Using Index Match is a method I think users will easily understand. In the meantime, I will still try and figure out how I can make my flow grab the proper Managers for Notification.
... View more
It's really difficult to troubleshoot using Run History. I can't sort or filter columns, and I have to open the runs one at a time to see the ID of the SharePoint list item it ran against. I tried downloading to CSV, but only get about 70 items. If I want to click a range of runs, I have to click them one at a time. It takes an inordinate amount of time to select and cancel runs. Thanks for listening.
... View more