Unanswered

LookUp Yes/No Data Type in OnStrat property

(0) Share

Report

Posted on by TW001

I am doing a lookup based on a dataverse table in OnStart. Below is my code.
Very confusing why the lookup result is empty. I also attach the screenshot of the table.

Set(
 CurrentAppVersion,
 "151"
);
Set(
 LatestAppVersion,
 LookUp(
 CSHHR_AppVersions,
 IsLatest = 1
 ).AppVersion
);
If(
 Value(CurrentAppVersion) <> Value(LatestAppVersion),
 Notify(
 "A newer version of this app is available. Please update to the latest version.",
 NotificationType.Warning
 )
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

TW001 92 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

Mitanshu 1,650 Moderator on at

Like (1)

Report
Your IsLatest column is a choice column rather than a number column. So your LookUp is having a data type mismatch.

Try something like below (you will have to adjust to your own column/table names):

LookUp( CSHHR_AppVersions, IsLatest = 'IsLatest (CSHHR_AppVersions)'.Yes ).AppVersion

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
TW001 92 on at

Like (0)

Report

Thanks for your answer. But it's still blank. I need get the correct version number.

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (0)

Report

I trust you have done App -> Run OnStart before checking whether you get blank or not - correct?
Do you get any error messages when you do App -> Run OnStart
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
TW001 92 on at

Like (0)

Report

Yes
Spoiler (Highlight to read)
LatestAppVersion = Error. (Error when trying to retrieve data from the network)
LatestAppVersion = Error. (Error when trying to retrieve data from the network)

Was this reply helpful? Yes No
TW001 92 on at

Like (0)

Report

I tried to updated the security role today and it works.

Was this reply helpful? Yes No