Help with expression in power automate

[JohnH70]

Hello I am in need of some assistance in writing a flow.

In get items I need assistance with the filter query. To write an expression to get the last pallet # used in "pallet tracker" SharePoint list. I don't know if it is best to grab the item last "ID" created to fetch the "pallet # column" or if it best to write and fetch the last pallet number used in list? 

Then once I get the last pallet # used I need to add +1. ( So example 250 was last used then add +1 to get 251) I am assuming using a initialize variable. But what expressions can be used to do this? i tried "last" expression and that didn't work

Any help would be appreciated. Someone click it as being spam on last entry so if I'm not posting in the right spot can someone please tell me where I can post to get some assistance. 

[creativeopinion]

@JohnH70 Instead of nesting the Get Items action inside an Apply to Each action, it's best practice to have this action OUTSIDE of the Apply to Each loop. Use a Filter Array action instead. This way you only ned to retrieve your items from your SP list once—use the Filter Array action to filter out the item(s) you are looking for based on the current row you are looping through.

To get the last pallet #, you can use the Order By field + Top Count field. Sort the pallet column in descending order. You will need to use the internal column name of your Pallet # column. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

---

The Get Items action will always return an array of items—even if it's a single item. To output the result of a single item while avoiding the Apply to Each action, check out this YT Tutorial: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[JohnH70]

That worked to get the correct last number used in get items, 

So now how do i add +1 to the correct number in this case it is 5601 + 1 = 5602

then add it to excel file to put in correct pallet number?

is it update row in excel?