Auto fill/suggest field name

(0) Share

Report

Posted on by yashm

Hi,

I have an excel sheet of Order Numbers (PO) which have different items in it. It looks like this:

I have made a manual trigger flow where I enter the respective PO number and the flow updates the Status column for all the line items to 'Received'. Like this:

This is how the flow looks like:

This is how I use it on the Flow app:

The flow is working fine. The only problem is I have to type in the entire PO number. It's usually 9 characters long. I want to have a function wherein I type the first 2-3 letters or any characters of the PO number, it should suggest the same to me and I click on it.

For e.g., I type, "LM100..", I should get the suggestion of "LM1000568" and then I click on it.

I think something like this can be achieved using Power Apps although I've never used them before. Can you tell me how can I use Power Apps to achieve this search function and integrate with the flow? Basically the same flow as above but the auto-fill suggest feature should suggest order number when I type in a few characters. Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

I am not exactly sure if this will work.
But instead of text input for entering PO number. take one combo box. In it's item property set Distinct values from PO number column.
turn on search property of combo box and once you start typing in number it will show you list of po numbers that contains your initial letters.

Was this reply helpful? Yes No
yashm 92 on at

Like (0)

Report

Hi,

I haven't used Power Apps before but I get what you're saying. Can I use the power app to trigger the flow and update the excel sheet? If yes, can you tell me how that connection works?

Let's say I choose the excel file with the data as the source for the Power App. Then I add the combobox function to it. From thereon, what's the next step. Can the power app send the selected PO number to the flow? Something like that?

Was this reply helpful? Yes No
yashm 92 on at

Like (0)

Report

I mean I have seen use cases where they you can update a single row using the Power App. But in my case I have multiple rows to update with the same value at once. How can that be done with Power Apps?

Was this reply helpful? Yes No
Verified answer

NiloferA on at

Like (1)

Report
Hello @yashm ,
Perhaps you can try Combobox in PowerApps. I have described the steps below
Create a Power App, add a connection to your Excel File
Click on Data from the Left Navigation
Click on Add Data and under Connectors locate Excel Online and click on it

You should see a list of Connectors to Excel Online, select one of them or add a new connection
After selecting the connection, you should see a right panel to choose the data set, select the "OneDrive for Business" as I see you are accessing your file from OneDrive in your Flow
Select One Drive again and then select your file from OneDrive
Select the Table
Select Sr No as the Unique Field and click on Connect
Add a Combobox and select the DataSource
Configure the Combobox as follows
Click on Edit near Fields and select PO as Primary Text and SearchField
In the Properties, set Allow searching to true
set Allow Multiple Selection to false
Change your Flow trigger to Power App and where you are passing PO Number in Filter, replace it with "Ask in PowerApps" Dynamic Content
Add a Button in your Power App, and go to Action and select Power Automate
Select your Flow from the List and complete the Formula in OnSelect of the Button as follows

This is how the final Power App should look like

Let me know if you are stuck anywhere while following these steps.
Please give a Kudo if you found this helpful or Mark this Reply as Solution if it solved your problem.

Was this reply helpful? Yes No
yashm 92 on at

Like (0)

Report

Omg! This is so detailed @NiloferA !
Thank you for taking the time out in doing this. Will definitely try and let you know how it went. Thanks again!

Was this reply helpful? Yes No
yashm 92 on at

Like (0)

Report

Hi @NiloferA! It worked! Thank you so much! You the best. Thank you for explaining everything step by step.

Was this reply helpful? Yes No
NiloferA on at

Like (0)

Report

Glad to know it worked, @yashm! 😉

Was this reply helpful? Yes No