Notifications
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.
Maybe the transform between the array length (number) and the returned traps (text), is failing?
From your screenshot this is the action that returns a value to the bot.
The right side of the action is blank. That will return a null value to the bot. You need to add some dynamic content to the action to actually return a value to the bot.
What do you mean there isn't a return value? What exactly on the flow isn't correct? I'm confused. The action is for Phone Tex to get the value from Phone in the table and output the value of the Traps? Am I missing something?
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.
Any one can give me help on why i'm getting this error?
Well I have to be doing something else wrong because the bot itself gives me an error
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.
Hey Pstork1,
I really appreciate the help and sorry if I'm frustrating with my lack of knowledge. I'm working on it!
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.
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?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 330
chiaraalina 124
Romain The Low-Code... 102 Super User 2025 Season 2
