Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Searching data from one column on Sharepoint and autofiling the rest - Power automate

(0) ShareShare
ReportReport
Posted on by 2
I'm fairly new with Automate. I've just been playing around with it for work and I cannot figure out my specific problem. I've been searching the web and testing flows out but cannot seem to figure this out.
 
I have a sharepoint list with multiple columns. Two of those columns I named number and date. Each number entered has it's own corresponding date. I'm trying to see how to build my flow so that when I input any number from that list, it can auto populate that corresponding date. 
 
For example:
number date
12345 10/30/24
6789 1/15/23
147852 8/16/24
 
and this table I've made a form through power app, where there's a section that asks for number and date. How can I make a flow where if I input 12345 in the number section, I automatically get 10/30/24? or when I input 6789 I get 1/15/23? Is this even possible?
 
Thanks in advance.
  • AA-30101432-0 Profile Picture
    AA-30101432-0 2 on at
    Searching data from one column on Sharepoint and autofiling the rest - Power automate
    Thanks @ScottShearer for responding. 
     
    I have done the method you suggested and it works. But how do I make it so that when I input any number on my Power App form, the corresponding date from the list will auto populate? This is assuming that I can connect this Automate workflow to the App that I made separately.
     
    As clarification, my company used to have Nintex to make forms and workflow. Now that we don't have it anymore, I'm learning how to use power app and automate in replace for Nintex. 
  • Suggested answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Searching data from one column on Sharepoint and autofiling the rest - Power automate
    I would not enter the date when creating the item in your Power App.
    I would use a Flow that runs when an item is created.
     
    You can use a switch action to set the a variable if there are not a lot of values in the number column.  Then, use the variable as the input for the date column.
     
    Another way is this:
    • Use a SharePoint Get items action to retrieve rows from the lookup list
      • Include an OData filter so that the only value returned is for the row containing your number
      • Assign the value to a variable
    • Use the variable as input to the SharePoint create item action
    If you need more help, just let me know
     
    Scott
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard