cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Kudo Collector
Kudo Collector

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
Kudo Collector
Kudo Collector

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

 

int3.png

View solution in original post

@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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (68,997)