web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Having trouble updatin...
Power Automate
Unanswered

Having trouble updating a lookup column with an array of values

(0) ShareShare
ReportReport
Posted on by 6
Hello, so I am creating an app in Power Apps that will be used for learning and taking courses. All the information is stored in a SharePoint site and I have multiple lists with information. I have a list called Estudiantes where I store students information like the courses assigned to them and their completed courses. Both columns of Assigned Courses and Completed Courses are lookup columns that reference the title column in another list called Courses and in both columns there can be multiple courses in the same field. 
 
I am creating a flow that is triggered by a Power Apps button, that when the student completes a course it automatically moves the course they just completed from assigned to completed. 
 
What I've done so far is trigger the flow with a Power Apps button and input the Student Name and Course from the app. I will a attach a screenshot of the progress. The flow right now has two variables: RemainingCourses and CompletedCourses. CompletedCourses supposed to store the already existing Completed Courses and add the recently completed one (this works). The problem comes from the RemainingCourses variable. For this variable I currently have an Apply to each assigned course (from the original list) and check with a filter array if they match with the recently completed course. I did this to eliminate the recently completed course from the assigned courses column. The problem is that when I try the Update Item action, it has an error and wont accept neither the variable, nor the outputs. I suspected that it needed the Id from the original value so I did a Select action and extracted the Id but it still wont run. 
 
The current error message I have is : OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/CursosAsignados/0/Id' is required to be of type 'Integer/int64'. The source type/format 'Array' of the value '[{"Id":6},{"Id":5},{"Id":16}]' is not convertible to type/format 'Integer/int64'.
 
Any help would be very much appreciated. Thank you!
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 813

#3
Haque Profile Picture

Haque 526

Last 30 days Overall leaderboard