cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GustavoDuarte
Frequent Visitor

Use Expression on Power Automate inside PVA (on teams)

I´m workin in a bot using the license for teams.

So I´m on PVA inside the Teams.

 

I need to call and action and in this action i need to use a expression to get a length of a collection. Is it possible?

 

In Power Automate on Web I know how to do that, but on Teams seems not to be possible.

1 ACCEPTED SOLUTION

Accepted Solutions
StevenA
Frequent Visitor

Edit:  I found out I could do it.  In Teams, my screen was zoomed in too far so I couldn't see the expressions.  As a side note, my colleague was able to do expressions within Teams, so I assume it is related to screen resolution.  I popped the Chatbot out into a browser window by doing Ctrl + click on the Chatbots tab.  From there, I was able to zoom out enough to see expressions.

StevenA_1-1626875231183.png

 

StevenA_0-1626875150155.png

 

@GustavoDuarte  I'm not seeing a way to access expressions, either.  

 

Can you tell me a bit more about your use case?  Are you making an API call and getting an array of items back?  Here are a couple options to consider.

 

1.  Sometimes, the API will return the number of items in a property that you can access directly.  Can you look at your collection to see if such a property exists?

2.  As a somewhat annoying but effective workaround, you could put your array inside an apply to each loop, increment a variable for each loop, then return the variable to PVA.  

 

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User
Dual Super User

One of the things you can do in PVA for Teams is to call an Action (Power Automate flow).  You can pass parameters into the flow and get a return value.  So you need to call a flow (make sure you create it from PVA so its in the right environment).  Then have the flow calculate the length of the collection and return that value.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
StevenA
Frequent Visitor

Edit:  I found out I could do it.  In Teams, my screen was zoomed in too far so I couldn't see the expressions.  As a side note, my colleague was able to do expressions within Teams, so I assume it is related to screen resolution.  I popped the Chatbot out into a browser window by doing Ctrl + click on the Chatbots tab.  From there, I was able to zoom out enough to see expressions.

StevenA_1-1626875231183.png

 

StevenA_0-1626875150155.png

 

@GustavoDuarte  I'm not seeing a way to access expressions, either.  

 

Can you tell me a bit more about your use case?  Are you making an API call and getting an array of items back?  Here are a couple options to consider.

 

1.  Sometimes, the API will return the number of items in a property that you can access directly.  Can you look at your collection to see if such a property exists?

2.  As a somewhat annoying but effective workaround, you could put your array inside an apply to each loop, increment a variable for each loop, then return the variable to PVA.  

 

Helpful resources

Announcements
Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

MS Build PVA Carousel 768x480.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development for Power Virtual Agents.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Users online (2,085)