Unanswered

PowerApp Sharepoint Set Variable not loading first time

(0) Share

Report

Posted on by NavasShereef

Hi all,

I am creating Power App form with SharePoint. I am trying to Set a variable while form loads. I tried to set variable in OnNew, OnEdit and OnView. When I open the form twice, I can load variable with the SharePoint value. However, It is not loading first time. The formula I am using is

Set(varComments,SharePointIntegration.Selected.Comment);

I don't know why it is not loading first time. Please help me out.

Thanks,

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

TiagoFreire 313 on at

Like
a
(0)

Report
Copy link

Link copied!

More information would be useful. is this a form customizing a sharepoint list, or a standalone canvas app?
The Form might be running its events before SharePointIntegration data loads, so Selected is blank.
That could explain why it only works on the second load onwards.
Use the Gallery's OnSelect to control the Form's state and have the user select an item to edit.

If the explanation does not seem to fit your app, please explain in more detail.
NavasShereef 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tiago,
Thanks for the reply. I am customising only Edit, New and display form of SharePoint list form and not using gallery because i am ok with default allitem.aspx page. When I click new or edit from allitem page, setting a variable fails. and when I try again it sets the variable.
TiagoFreire 313 on at

Like
a
(0)

Report
Copy link

Link copied!

Ahh, memories.

SharePointIntegration.Selected is Blank or Empty the first time it loads.
So all the action will find no data.

It's not a bug, it is an "opportunity for improvement". I have been through PowerApps Support with this.

You can either have a "reload" button in your Form (which is awkward, since you loaded it from a selected item already), to manually re-check for the data.
Or have a timer with a short loop continuously check the SharePointIntegration.Selected property until it loads. Then populate your vars and stop the Timer.
amitabha169516 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tiago,
Could you please explain how to use timer in this case? Please explain with example.
TomSlosse_ 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @TiagoFreire

I know it's been a while, but could you elaborate on your workaround for this issue?
Thanks in advance.

Kind regards

Tom
TomSlosse_ 9 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @amitabha169516

I know it's fairly late to reply and maybe you found the solution but I just wanted to give my experience with it.
I fixed this by selecting the SelectedListItemID, apparently there is no delay on that.
So in the OnStart or OnView, OnEdit or Onvisible you can do something like this:
Set(varComments, Text(LookUp(<yourDatasource>, ID = SharePointIntegration.SelectedListItemID).Comment));
That did the trick for me.

Kind regards

Tom