cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
avt
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
avt
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
avt
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
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (47,983)