{"id":47,"date":"2021-08-08T09:31:01","date_gmt":"2021-08-08T01:31:01","guid":{"rendered":"https:\/\/pearsongang.com\/?p=47"},"modified":"2021-08-08T09:34:55","modified_gmt":"2021-08-08T01:34:55","slug":"power-apps-canvas-frustrating-error","status":"publish","type":"post","link":"https:\/\/pearsongang.com\/?p=47","title":{"rendered":"Power Apps – Canvas – Frustrating Error"},"content":{"rendered":"\n
\"\"
Oh No!!<\/figcaption><\/figure><\/div>\n\n\n\n

The error message I am afraid to see when building a canvas app is:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This is a particular bad error message to get. Especially, if you have been coding for a while without monitoring the errors that may have been introduced. Time to debug this message is not small. At end of this article I suggest a possible timesaver.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Coding without checking errors<\/strong><\/p>\n\n\n\n

Yes this does happen to me in particular. For example I know I have used a new variable, but the declaration will come on a different event. Thus this ‘known error’ may mask any other errors you may introduce.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Brief Basic Background<\/strong><\/p>\n\n\n\n

Some basics about record types:

UpdateContext(
{ l_personSoccerRec:
{
soccerperson : GUID(),
firstName: “Joe”,
lastName: “Bloggs”,
favouriteTeam: “Chelsea”,
mostExcitingPlayer: “Grealish”
}
}
);<\/p>\n\n\n\n

This data called be setup using individual variables:
<\/p>\n\n\n\n

UpdateContext( {l_soccerPerson: GUID()});
UpdateContext( {l_firstName: “Joe”});
UpdateContext( {l_ lastName: “Bloggs”});
UpdateContext( {l_favouriteTeam: “Chelsea”});
UpdateContext( {l_ mostExcitingPlayer: “Grealish”});

By reading the data, it should be clear that the first sample code is far cleaner to read.
There are multiple articles, that will dig deeper into reasons.<\/p>\n\n\n\n


Retrieved from Table<\/strong> <\/p>\n\n\n\n


<\/strong>If retrieved from a table the record may be populated by
UpdateContext( { l_personSoccerRec: LookUp(SoccerPeople: soccerperson = [guid] )}) \/\/[guid] is pseudo syntax

<\/p>\n\n\n\n

Retrieved from Form<\/strong><\/p>\n\n\n\n

UpdateContext(
{ l_personSoccerRec:
{
soccerperson : GUID(txtFirstName.Text),
firstName: txtFirstName.Text,
lastName: txtLastName.Text,
favouriteTeam: txtFavouritTeam.Text,
mostExcitingPlayer: txtExcitingPlayer.Text
}
}
); <\/p>\n\n\n\n

Huge Assumption<\/strong><\/p>\n\n\n\n

The table does not reference other tables, so not normalised etc. Thus not optimally designed.<\/p>\n\n\n\n



Introduce the Error<\/strong><\/p>\n\n\n\n


UpdateContext(
{ l_personSoccerRec:
{
soccerperson :txtFirstName.Text,
firstName: txtFirstName.Text,
lastName: txtLastName.Text,
favouriteTeam: txtFavouritTeam.Text,
mostExcitingPlayer: txtExcitingPlayer.Text
}
}
);

Error Message is Cryptic<\/strong> <\/p>\n\n\n\n


Incompatible type. We cant evaluate your formula because ….
<\/span>
This is really not helpful. In this example there is only 5 fields, but there could be many more.
<\/p>\n\n\n\n

Please Microsoft<\/strong><\/p>\n\n\n\n

Please can you advise the fieldname, even if the issue is on more than one field. One field at a time will be a huge improvement.

Time Saver<\/strong>

Let me say I save and also save to my computer lots. If this type of error has taken over 15 minutes (and it can easily). I reload from my last “Save”.<\/p>\n","protected":false},"excerpt":{"rendered":"

The error message I am afraid to see when building a canvas app is: This is a particular bad error message to get. Especially, if you have been coding for a while without monitoring the errors that may have been introduced. Time to debug this message is not small. At end of this article I […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"WB4WB4WP_MODE":"","WB4WP_PAGE_SCRIPTS":"","WB4WP_PAGE_STYLES":"","WB4WP_PAGE_FONTS":"","WB4WP_PAGE_HEADER":"","WB4WP_PAGE_FOOTER":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12,13,11,1],"tags":[10],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-canvas-app","category-errors","category-power-apps","category-uncategorized","tag-power-apps"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pearsongang.com\/index.php?rest_route=\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pearsongang.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pearsongang.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pearsongang.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pearsongang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47"}],"version-history":[{"count":3,"href":"https:\/\/pearsongang.com\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":52,"href":"https:\/\/pearsongang.com\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/52"}],"wp:attachment":[{"href":"https:\/\/pearsongang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pearsongang.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pearsongang.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}