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

(0) Share

Report

Posted on by AA-30101432-0

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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
AA-30101432-0 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No