Skip to main content
Community site session details

Community site session details

Session Id : kowZ1FZrMAReH5yqWjTK3v
Power Automate - General Discussion
Unanswered

Trying to create a flow that will move a Calculated Column output into a Lookup Column if they match

Like (0) ShareShare
ReportReport
Posted on 11 Nov 2018 20:54:59 by 72

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?   

  • v-yuazh-msft Profile Picture
    on 13 Nov 2018 at 07:13:45
    Re: Trying to create a flow that will move a Calculated Column output into a Lookup Column if they m

    Hi @neds,

     

    It's possible to achieve your needs within microsoft flow, you could take a try on your side to split the file name, get the Account and the Biller from the file name.

     

    Best regards,

    Alice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete