Int Expression PowerApps

(0) Share

Report

Posted on by JB0007

308

Hi Power Automate community,

I am using a flow to respond back to PowerApps. I have a PowerApps trigger and than Get Items from SharePoint. The Get Items from SharePoint requires an ID, but this ID is only applicable for the ID of SharePoint itself. I want the Get Items ID to be another ID which is for example Client_ID. This Client_ID I want to be able to specify it in a TextInput and thereafter for flow to return the data for that Client_ID. But when I enter the Power Automate code in the Onselect button, it won't let me enter the TextInput name. It says it expects 0.

Can someone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Christopher S Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @JB0007

The ID that the Get Item action requires is always going to be the SharePoint ID, which you can retrieve in your application and send it as a parameter to the Flow, otherwise, you will need to use the Get Items action that retrieves a list and in that one, you can filter using the new column that you want to create. You can find some filtering information on the following URL: https://flow.microsoft.com/en-us/blog/advanced-flow-of-the-week-filtering-with-odata/

Best Regards
--
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
DevendraSingh 144 on at

Like (0)

Report
Copy link

Link copied!

Hi,
SharePoint get item "Id" column value must be a number. When you are attaching a Power automate flow, the entered value of text box value must be a number. If the value is blank or text, which can not be converted into a number, it will not allow you to add flow.
On the button "OnSelect" property add the condition, execute flow only if the entered value is in the text box can be converted into a number, i.e. If(IsNumeric(TextInput1.Text), 'PowerApp->Getitem'.Run(TextInput1.Text))
Please click Accept as Solution, if this solution solved your issue. If this post was useful, please consider giving it Thumbs Up.

Thanks & Regards,
Devendra Singh

Was this reply helpful? Yes No
JB0007 308 on at

Like (0)

Report
Copy link

Link copied!

Hi @DevendraSingh, thanks for the reply.

I have test the code and it seems to running fine when I entered the original SharePoint ID. The problem is to switch that ID into my custom ID which MS Flow is not permitting. I have insert a Filter function to filter on my custom ID but I need a function to return the corresponding original ID of that custom ID. Do you know which function I can use to achieve this? For example a LookUp function but in Flow?

Was this reply helpful? Yes No
DevendraSingh 144 on at

Like (0)

Report
Copy link

Link copied!

Hi,
As per my understanding, you want to filter the SharePoint list item based on the custom column instead of the internal column ID. Use SharePoint get items action in the flow, and write OData filter in Advanced options=>Filter query, i.e. CustomColumn eq value. The output will be an array, so you have to fetch the record from an array, you can use apply to each for that.
Please click Accept as Solution, if this solution solved your issue. If this post was useful, please consider giving it Thumbs Up.

Thanks & Regards,
Devendra Singh

Was this reply helpful? Yes No
JB0007 308 on at

Like (0)

Report
Copy link

Link copied!

@DevendraSingh thanks for the reply.

I have change my flow to: Power Apps Trigger -> Get Input from PowerApps -> Get Items -> Filter Array:
So I am not using Get Item anymore. As a follow up to your response, do you know how I can fetch this array/ table to Power Apps? I am new to Power Automate.

Was this reply helpful? Yes No
DevendraSingh 144 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Use Request connector to send a response to Powerapps(refer to the attachments).
Please click Accept as Solution, if this solution solved your issue. If this post was useful, please consider giving it Thumbs Up.

Thanks & Regards,
Devendra Singh

Was this reply helpful? Yes No
JB0007 308 on at

Like (0)

Report
Copy link

Link copied!

@DevendraSingh

I have this as my Flow:

I have use ClearCollect in my Onselect button to create a collection. I have also connect my gallery with the ClearCollect name, but I only see "true" in the Gallery and I cannot add more fields. Further, the Response doesn't let me use the body of Select, I hsve choose body of Filter. Do you know how can I display the name and more information?

Was this reply helpful? Yes No