Announcements
Whoever thought of Oquery and Dataverse connections on Power Automate needs to be fired from Microsoft. Its just such a headache to do simple things. OK: I want for a user to be able to go on PVA and say they have an issue with their product. We have THREE products. The idea of the flow would be Ask user for their phone number: After the input the system should look in the table and look for the user's Product (on the Table as 'Traps'). Table will look like this,:
So if the user looks up: 44444444 their number, then I want it to give me the value of the 'Traps' column. After this if (its a multiple choice list) user has more than one trap I would then do a condition in PVA to ask which one their having issues with. My problem is I can't figure out how to use a phone to get the value from the traps column. I've read Microsoft articles and seen videos but no one quite explains it correctly that doesn't leave me confused and stuck.
1) List Rows from the table filtered by phone number
2) Use First() to get the first row in the resulting array. Add .Traps to get the Traps array.
3) The Length of the Traps array will be how many products they have 1, 2, or 3. Even if its only 1 Traps will still be an array.
I'm confused, I got the first stop down but don't understand what you mean by 'Use first() to get the first row in the resulting array'
First() is a function in Power Automate that lets you return the first row from an array of rows. Since Traps is a column in the record you need to isolate the first record to get at the values in the column. You could do this in a Compose action.
Where would I put that? You're steps arent really telling me where to put anything, just to put first() and get trap array. I have no idea what you're asking me to do. Where would I put this compose action? In the List rows advance options? Is there a link I can get something that breaks it down better?
Can you show a screenshot of the flow you are using? Then I can give you a better idea of where to insert the actions. But to provide some context.
Hey Pstork1,
I really appreciate the help and sorry if I'm frustrating with my lack of knowledge. I'm working on it!
You're close. The point of using the First() function is to avoid having it stick an apply to each loop around the output. But you have to insert the function using the expressions tab in the dynamic content dialog. You can't just type it in. Add a Compose right after the List rows action. Then use the dynamic content dialog to insert First function around the value from the list rows.
Well I have to be doing something else wrong because the bot itself gives me an error
Any one can give me help on why i'm getting this error?
The screenshot of the flow you posted doesn't actually return a value. The field you return isn't filled in. That would cause this kind of error.
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Romain The Low-Code... 240 Super User 2026 Season 1
Valantis 226
Arild Aarnes 73 Super User 2026 Season 1
