Apex Code Development You need to sign in to do that
Don't have an account?
process automation specialist step 6 - Error: Faraday::ClientError. Message: MALFORMED_QUERY
There was an unhandled exception. Please reference ID: KLNTXAZY. Error: Faraday::ClientError. Message: MALFORMED_QUERY: When retrieving results with Metadata or FullName fields, the query qualifications must specify no more than one row for retrieval. Result size: 2
I have a flow that allows you to choose the product type, then the product, which creates the product, then asks if you want to add more products and goes back to the start. Seems to work perfectly. Not sure what this error is.
I have one quick question : Did you create products by your self on this challenge ?
I have no Product where product name contains RainbowBot, CloudyBot or Assembly System for now
And I succeed to pass the challenge even if my flow simulations are wrong and I do not understand why it is wrong
I inspired myself from this video : https://www.youtube.com/watch?v=NW8i8SEeayg&t=532s
1) Screen with 3 choices and store the result in screen choice fields : ProductType
2) Lookup to find records in product2 with contains ProductType and store them as variables (Id + name) // Here the ProductType is the one I have chosen, but result are not right products... I am still wondering why.
3) Screen to display variables
4) Activate the flow
5) Add the flow to the opportunity screen
6) That's it -> Check Challenge
https://login.salesforce.com/packaging/installPackage.apexp?p0=04t46000001Zc8v
Here's the link to the associated help article. They were very easy to miss, they don't look hyperlinked:
https://force.desk.com/customer/en/portal/articles/2710899-installing-a-package-or-app-to-complete-a-trailhead-challenge?b_id=13478
- Screen with Choice to select Product Type
- Lookup to Product2 where Name CONTAINS the option chosen on Screen 1.
- A Screen showing the variables found?
I attempted that and still cannot pass the challenge.Thank you all effectively, I did not deploy the playground that's the reason why
@Stevie here are my screenshots
I passed the challenge before Trailhead was shut down for maintaince so I don't know if my flow would still pass but all I had was 2 screens, 1 record lookup, and decision. I believe the challenge just checks to see if a flow is on the lightning page more so than if it operates correcly.
2 screens only as the lookup is done on the second screen based on the option from the first screen. (lightning component could do it without second screen)..
Make sure that the list is filtered correctly for the 3 options (cloudybots has none for me), make sure to have the name and id fields.
This is a technical error.
Go to Setup > Object Manager > Opportunity > Lightning Record Pages and ensure you have only one lightning record page.
@Mickael Raoul
- You don't need a product lookup between the two screens.
- The Dynamic Record Choice should reference {!ProductType} as a filter value on name field
I clear this challenge at developer edition with input the Robot data manually.
Step1 : Click the Products from App Launcher
Step2: Manully insert product, with product family as RainbowBots, product name as Large/Medium/Small RainbowBot
Hope this can make a difference.
Sophie
That being said, my next challenge, personally, is to figure out how to make the flow work. Flows are not my strong suite. I followed much of the advice in this post and another one on Step 6, and while they got me in the right direction, the flow still won't work - it shows another, single product that doesn't include any of the keywords defined in the requirements. Frustrating, indeed!
Here is my basic flow design:
I did deviate from the what others had done and added the Product Family to each of the related products (Product Family picklist: Rainbowbot, CloudyBot, Assembly System). I decided to do this since I felt it (1) simplified the flow and (2) provided a more real world solution to the request as using a standard picklist field aligns better with best practices. I also decided to use a picklist in the flow instead of radio buttons.
The Fast Lookup basically looks up the product family, but I saved the Family, Name, and Id in the Variable. I used a Loop Palette to gather all of the Products in the selected family, and used the Assignment Palette to compile all of the products for the final screen (note: I am not 100% sure this palette is necessary, but I am not going to chance breaking my flow to find out!). The final Screen Palette is another picklist that spits out the Products in the specified Product Family. Here are my results:
The picklist view kept going back to the selection, but all three options are available.
I hope this helps!
If you are still stuck Please find the detailed step by step solution in the below link:
https://techexcellence09.blogspot.com/2018/06/process-automation-specialist.html#more
Setup -> Object Manager -> Opportunity -> check for more than one record!!
Here is the Error:
There was an unhandled exception. Please reference ID: DWUENIEI. Error: Restforce::ErrorCode::MalformedQuery. Message: MALFORMED_QUERY: When retrieving results with Metadata or FullName fields, the query qualifications must specify no more than one row for retrieval. Result size: 2
Close errors
Here is my Results
Every time I tick one of the boxes, save the record and refresh the screen the products change. I'm lost, the flow is working great but the error I don't understand what to fix. Any thoughts?
here is a link to the fix by Kahn Anas
https://developer.salesforce.com/forums/?id=9062I000000IH6AQAW