cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhitchlockfcs
Level: Powered On

Dynamic content from Common Data Service is returning Null

I have a strange issue I cannot figure out.

 

I have a flow which when triggered should retrieve one record and then create a related record with values being a percentage of the source records. Seems straightforward, however the Flow fails on the create record step with the following error: 

Unable to process template language expressions in action 'Create_PC_Line_Based_on_QS' inputs at line '1' and column '2726': 'The template language function 'mul' expects its first parameter to be an integer or a decimal number. The provided value is of type 'Null'. 

The Expression referred to is a simple multiplication statement: 
mul(body('Get_the_QS_Coverage')?['ssru_blanketlimit'],variables('QSPct'))

 
When I look at the output from the 'Get_the_QS_Coverage' action I see all of the values in the output:outputs.png

 

To test I tried initializing variables with the field values but same issue arises no actual values are returned from the get record action. variables.png

 

I'm stumped. Can someone help me figure this out?
 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dynamic content from Common Data Service is returning Null

Hi @bhitchlockfcs 

 

Thanks for your quick reply.

 

Please try this expression.

 

mul(body('Get_the_QS_Coverage')?['value']?[0]?['ssru_blanketlimit'],variables('QSPct'))

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

7 REPLIES 7
Super User
Super User

Re: Dynamic content from Common Data Service is returning Null

Hi @bhitchlockfcs 

 

Could you post your retrieve flow step screenshot please?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



bhitchlockfcs
Level: Powered On

Re: Dynamic content from Common Data Service is returning Null

Sure, @abm  the retrieve step is below. Followed by the results.retrieve.pngretrieve results.png

dynamiccontent.png

Super User
Super User

Re: Dynamic content from Common Data Service is returning Null

Hi @bhitchlockfcs 

 

Try this

 

mul(body('Get_the_QS_Coverage')?['value']?['ssru_blanketlimit'],variables('QSPct'))

 

Let me know the result.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



bhitchlockfcs
Level: Powered On

Re: Dynamic content from Common Data Service is returning Null

Thanks @abm, tried that sadly just got another error:

 

Unable to process template language expressions in action 'Initialize_Building_Limit' inputs at line '1' and column '2726': 'The template language expression 'mul(body('Get_the_QS_Coverage')?['value']?['ssru_blanketlimit'],variables('QSPct'))' cannot be evaluated because property 'ssru_blanketlimit' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Super User
Super User

Re: Dynamic content from Common Data Service is returning Null

Hi @bhitchlockfcs 

 

Thanks for your quick reply.

 

Please try this expression.

 

mul(body('Get_the_QS_Coverage')?['value']?[0]?['ssru_blanketlimit'],variables('QSPct'))

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

bhitchlockfcs
Level: Powered On

Re: Dynamic content from Common Data Service is returning Null

Thanks @abm  that worked!

Any idea why the body fields need to be formatted that way? I have several more values to use in my flow and it appears I have to type the body expression for each value.

Super User
Super User

Re: Dynamic content from Common Data Service is returning Null

Hi @bhitchlockfcs 

 

That's great.

 

The value is an array collection. Please see your earlier screenshot you provided.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,925)