Announcements
When i try to write Unique formula in excel using Power Automate Desktop get error in applying formula in excel like
=@unique instead of =unique. please help us ho
I cant get What you want to do
If you want to remove duplicates you can remove
by the following
create list activity
add data in excel by Add items to list activity
then use remove duplicates from the list activity
Hope this helps
Usha
I want to get unique value from Sheet1 Row AO after the getting value update countif formula for counts for rows.
My actual issue is when i try to update Unique formula in excel but automatically "=@" in excel due to which unique formula is not working. if you have any way to rid "=@" in excel its very helpful.
Then can you try the following
use the retrieve data table column into the list activity and add the required column to list
then use remove duplicates from list activity
and remove duplicates
Usha.
You have variable Unique right?
Try this use replace text activity and then for example as shown in the below
Instead of Getting Unique value through excel formula "=Unique()" use with data table list activity.
Thank you So much!!!
Welcome!!
Happy automation.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 253 Super User 2026 Season 2
11manish 172 Super User 2026 Season 2
trice602 134 Super User 2026 Season 2
