Offline Canvas App

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am creating offline canvas app. On Start I have this-

Set(
loggedinuser,
User().Email
);

Now based on logged in user mail I am fetching the contact GUID using below syntax but it is not working-

LookUp(
ContactCollection,
emailaddress1 = loggedinuser,
contactid
)

emailaddress1 is having email as datatype. I want it in offline mode as well.

How can I achieve that?

please help
@WarrenBelz
@RandyHayes

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

What is the issue you are having? If it is the message in the Formula Editor, I wouldn't concern myself so much with it...the editor shows this often on formulas. It usually indicates that whatever it is "seeing" is Blank.

That would lead me to ask if the formula you have is returning a result? I don't see the rest of your formula in the picture to know if you are trying to set this to something or what (and where - I assume OnStart as you mentioned that).
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes ,
My concern is my formula is not returning any result. This application is for OFFLINE mode also. Scenario is - I have two entities "Contact" and "Bus". Also, I have Contactlookup field in Bus entity and Email field in Contact entity. Based on logged in user email, I will pick guid from Contact entity. For that I have used below formula and it is working-
LookUp(
ContactCollection,
UserEmail.Email= loggedinuser,
Contact
)

And, now based on the contact guid, I want to fetch guid of that particular record from Bus entity and for that I have used below syntax and it is not working, it is returning blank-
LookUp(BusCollection,'Contact Lookup'.Contact=LookUp(
ContactCollection,
UserEmail.Email= loggedinuser,
Contact
),Bus)

Please note that I want this in offline mode.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Understood about the offline need. However, you do need to initially be connected to gather the data.

As for your formula not returning anything, you mention that the first formula returns the information that you want and the second does not. So, I would look at the comparison in the formula with the Contact in the 'Contact Lookup' and the one returned from your ContactCollection Lookup. They are obviously not equating and thus you are getting no results. Perhaps you would be better to compare email to email for the two contacts rather than record to record.