cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

converting string into Initializing Integer Variable action

Hello,

I have a lookup collum in a SHP list (its a ID lookup as additional collumn from Title), MS Flow tells me its a string.

So when trying to initialize it as a integer variable I get the following error(1st screenshot).

I tried It with two compose actions (tried it with one also - no luck)

 

int.png

 

The flow looks like this, I'll be happy to get rid of the compose actions.

 

int2.png

 

The point of the "initialize as variable" is to input it int a SHP "get item" action as ID (and the ID field only takes integers, but the lookup is string 😞 ).

 

I tried every syntax I could find in 

https://powerusers.microsoft.com/t5/Building-Flows/Initializing-Integer-Variable/m-p/46116

https://powerusers.microsoft.com/t5/Using-Flows/Error-when-initializing-an-integer-variable-with-an-...

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Casting-string-to-integer/m-p/38378

 

Please help I am stuck on this. Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Kudo Collector
Kudo Collector

Re: converting string into Initializing Integer Variable action

nevermind I figured it out, in case anyone wonders, that lookup is not string but object.

 

int3.png

View solution in original post

2 REPLIES 2
Highlighted
Kudo Collector
Kudo Collector

Re: converting string into Initializing Integer Variable action

nevermind I figured it out, in case anyone wonders, that lookup is not string but object.

 

int3.png

View solution in original post

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: converting string into Initializing Integer Variable action

@avt Let's hope the Expressions functionality recently announced will apply to Variables action blocks also; meaning instead of adding Compose + Initialize variable, we will just need to add Initialize variable

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

 

 

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,190)