get value of powerapps in MS Flow

[VineethKN]

Hi All,

  i have 3 columns in PowerApps (Region, Country and State)

 am invoking an MS flow from this powerApp, i want to getItems From Sharepoint using above powerapps values in filter,

How can i achieve this, since when i select the Ask in PowerApps options, it gives GetItem_FilterQuery, how can i select the exact field value.

Thanks in advance

[WarrenBelz]

Hi @VineethKN ,

You are welcome to post here, but you will probably get a quicker and more focused response from the experts over at the Power Automate Community.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[v-bofeng-msft · Accepted solution]

Hi @VineethKN :

Because I am not very clear about the function of your flow, I assume that you have the following requirements: the three values of Region, Country, and State of the specified record are passed to flow as 3 text variables. I assumed the specified record is the first record.

I’ve made a test for your reference:

My data source:

ClearCollect(mytest,{Region:"Region1",Country:"Country1",State:"State1"},{Region:"Region2",Country:"Country2",State:"State2"})

Create a flow:

1\Create a flow(GetValue)

Action-Power Automate-Create a new flow

Attention：

• the trigger must be PowerApps.

• the flow and your app must be in the same environment.

In your PowerApps app:

2\add the flow

Action-Power Automate- GetValue

3\Add a button

OnSelect:

GetValue.Run(First(mytest).Region,First(mytest).Country,First(mytest).State) /* Region, Country, State in the first record */

If you select the button, the three variables(Region, Country, State) in the process will get the values of the three parameters(First(mytest).Region,First(mytest).Country,First(mytest).State) in order.

Best Regards,

Bof

[VineethKN]

Hi Bof, thanks for the reply, am not sure if am doing it wrong,

i created 3 variables in my flow as you have specified, and in the powerapps called the flow on button click with direct call of values, it worked for me , can you please let me know , whats the significant use of ClearCollect,  below is what i have in my powerapps button click PowerAppsbutton.Run(ddRegion_gr.SelectedText.Value, ddCountry_gr.SelectedText.Value,ddState_gr.SelectedText.Value)

Thank you

[v-bofeng-msft]

Hi @VineethKN :

ClearCollect is what I use to create collections. I use the collection it creates as my data source. Because you already have a data source, you do not need to pay attention to it.

Best Regards,

Bof