Answered

Converted string to INT how do you return it to the original Get Items data?

(0) Share

Report

Posted on by mad05150

So I'm trying to get data from a SharePoint list. The data is a number formatted as a string.

I've used INT to convert a DaysRemaining string to an integer within the flow, and I can see that it was successful, but I cannot combine it back to the original data to

1. Filter the array on DaysRemaining < 90

2. Create a CSV attachment to an email of the filtered data with other fields.

I know how to capture output to a CSV attachment.

What I'm having trouble with is getting the original data ie. Product, TeamLead, etc connected with the converted integer. So I can filter the array for just the items I want, then output that to the CSV.

Hope I'm explaining this correctly. This is my 3rd day working with Flows 🙂

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @mad05150

Could you please post a screen shot of your flow?

Thanks

Was this reply helpful? Yes No
mad05150 on at

Like (0)

Report
Copy link

Link copied!

Full disclosure, I've added and deleted so much from the flow trying to learn it. This is where I'm back to currently.
Only have the string conversion left.

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @mad05150

Try the following

Expression I used above is as follows:

int(item()?['TaskId'])

Was this reply helpful? Yes No
mad05150 on at

Like (0)

Report
Copy link

Link copied!

Ok one last thing. I've added to that function and checked to see if it was less than or equal to 0. Which returns true/false correctly. Can I filter the array to just select the true items?
I can't seem to get that to work.

Thanks!!

Was this reply helpful? Yes No
mad05150 on at

Like (1)

Report
Copy link

Link copied!

I figured it out. the create table was referencing the wrong output. Thanks for all your help!!!

Was this reply helpful? Yes No