Power Platform Community Forum Thread Details

Hello!

I have a flow that takes JSON as an input. In my code, I set my variable varFormattedNewRecord to the result of a Lookup function that makes an ID that's found on the screen (The ID will return a match, the user could not possibly be on the screen without a matching ID). For some reason the Lookup is only returning 2 fields, instead of any of the other 9 possible fields from the dataverse(could be 25). What could be the issue? Is there a workaround?

It's also important to note, "Submit Form" will edit the record in the dataverse with the information inputted on the screen.

Here is my code:

SubmitForm(Form2_1);
Set(varFormattedNewRecord,JSON(LookUp(Retrospectives,EngagementID=TextInput2.Text),JSONFormat.IgnoreUnsupportedTypes);
CreateCSV.Run(varFormattedNewRecord);
Navigate('Home Screen');
Notify("Project Retro Successful Updated")

The value of varFormattedNewRecord is {"cr7f3_id":"E-51536747","cr7f3_retrospectivesid":"27690d25-af66-ed11-9562-002248272172"}.

I would want it to include the following data which is present in the dataverse record

[ { "cr7f3_didpoorlystopdoing": "text", "cr7f3_didwellkeepdoing": "text", "cr7f3_id": text, "cr7f3_name": "text", "cr7f3_projectspiciness": integer, "cr7f3_retrospectivesid": "text", "cr7f3_startdoing": "text", }]

Categories:

Building Power Apps