Trying to create a flow that will move a Calculated Column output into a Lookup Column if they match
I have a sharepoint file library that tracks bills (pdf's) and a sharepoint list that tracks Accounts and another that tracks Billers. In the bill file library I have two lookup columns that correspond to those seperate lists (Accounts and Billers). The file name is in a format comprised of Date, Account Paid From, Biller and Amount: named in a consistent format as follows "YYYY-MM-DD Account - Billler $0.00" I currently scrape the Account and the Biller in a calculated field in the library, then match those manually in the LookUp columns. I want to automate the metatdata selection of the Account and the Biller lookup fileds directly from the file name or from the calculated fields. Is that possible?