Int Expression

(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:

General topics

All responses (14)

Answers (1)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JB0007

Could you please explain when I enter the Power Automate code in the Onselect button? Where is this onselect button. In your powerapp?
JB0007 308 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @abm thanks for the reply.

Yes the code is in the Onselect button, for example Flow.Run() and I need to specify the Get Item ID which should be Flow.Run(TextInput1.Text). But according to the error the Run function is not expecting any value.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JB0007

Thanks for your reply. Could you please post the trigger of your flow?

Thanks
JB0007 308 on at

Like
a
(1)

Report
Copy link

Link copied!

@abm sure,

As you can see, it is a Power Apps trigger and when I enter the textbox it showed me this error. Further, in the integer expression I have code it from scratch. Most of the times when I am using an expression, it let me use an expression it let me choose from the dynamics but in this case it haven't.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JB0007

Remove the existing flow connection from your PowerApp and add it again. Looks like there is a refresh issue here.

Thanks
JB0007 308 on at

Like
a
(1)

Report
Copy link

Link copied!

@abm I have tried it but unfortunately it keeps doing the same thing.

Maybe I need to change the code in expression?
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JB0007

What happens when you set the code flow.run is that shows (preview) it expects any parameter?

Thanks
JB0007 308 on at

Like
a
(0)

Report
Copy link

Link copied!

@abm

it gives me this error:
WillPage 2,339 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Add a Compose action into the flow, straight after the trigger. In it, find "Ask in PowerApps" dynamic content. Now save and then back in your App, remove the flow from the app and re-add it. The output of the Compose action can be used in the ID field of the Get Item action.

Of course you can put "Ask in PowerApps" directly in the ID field of Get item, but it locks you into a particular data type, while Compose is data type: any.
JB0007 308 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WillPage , thanks for the reply.

I have tried with the compose input in the ID field but it will not return any values. Now, after the compose input I have insert a Filter function to filter the Get Items lists on the value in the compose inputs, but I don't know what to do next in order to get the ID that correspond the value in compose inputs. Do you know how can I insert a function that is similar to LookUp in Flow?