Unanswered

Create an Array and update a list with the values

(0) Share

Report

Posted on by golfnutt82

1,362

I need to develop a complex workflow.
Can what I have described below be done with Power Automate?
If so, how do I create the arrays to handle this type of work?

I have a list called "Inventory"
This list captures the names of software we currently have licensees for.
The selections of the Assigned Software are held in the field LU_Assigned Software.

I have another list where the assigned software is allocated to the user

So, you can see from the above list, Machine / PC Name has the installed software.

In the "Software Users Inventory" list an entry needs to be made for each piece of software for that machine.

Based on what was entered and even at some point removed there is a third list that holds the license count.
When someone updates the Inventory form by either adding or removing a piece of software the totals should change.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@golfnutt82 you can create a flow on item update of Software users inventory list, then get items from the same list filtered by current items' Assigned software column value. The count of items returned by Get Items could be the license count that you can update in another list.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like (0)

Report
Copy link

Link copied!

Hi Annajhareri,
The "Inventory" list is the initiating list where software is added and or removed.
Based on the software titles in the Lookup column I need to split those names out and then create those items in the "Software Users Inventory" list and then update the "Software Inventory" license count.
Trying to figure out how to build that scenario.
Thank you for your feedback

Was this reply helpful? Yes No