Answered

Data often are not loaded: textinput / gallery (reading data from Sharepoint) / dropdown menu issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am facing issue related to loading data between Dropdown menu selection / gallery (including many of text input fields, reading data from SharePoint list) / and HTML TEXT field. It looks like this is PowerApps bug, but I believe that there is some possible workaround to overcome.

What is the purpose of my PowerApps tool?

I have created tool where selecting one position from dropdown menu loading to HTML text field specific other data from the same row in the SharePoint list. Dropdown menu includes entries from one of columns from this SharePoint list. This HTML text field is the preview of the email content which will be send based on Office365Outlook.SendEmailV2 (sending email feature works correctly).

How the tool is built (brief description)?
Dropdown menu:
"Items" - SharePoint list name
"Value" - one of the column name

I have hidden Gallery configured as below:
Filter('SharePoint list Entries','ID Column'=DropdownEmail01.SelectedText.Value)

Gallery has inside many textinput fields reading data from proper SharePoint column:
"Data" fields - "Defaults" are entered as eg. "ThisItem.'ColumnName01'.

And I have HTML TEXT field which has a content like:
Answer01: ABC.

Exemplary ABC is loaded data from Gallery based on textinput name where is linked this above 'ThisItem.'....

This HTML text field is configured like:
"Answer01: " & textinput01.Text & "."

Where is the problem?

Often when I select entry in the dropdown menu, all the data from Gallery are not loaded. There is the temporary workaround for this but only in edit mode: when I will cut the Gallery from the screen and then paste gallery again from clipboard, entries will work properly in HTML text field. I can chose anything from dropdown menu and HTML TEXT field will load whole data always till I will not close edit mode. But I can't apply this for play mode.

Ideas to overcome the issue but I don't have idea how to manage:
- some delay in loading gallery first before loading data to the html filed
- some hidden ordering when I choose new entry in dropdown menu then load Sharepoint row in Gallery first, then load data to HTML TEXT input filed based on textinput name connected to Gallery.

Thanks everyone for your ideas in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

rimatos Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Not sure if this will help you in your particular situation, but if you need too create a delay, you can use a timer control, as depicted in our documentation here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-timer

You can set the duration you want and then tell the timer which action you would like to perform with OnTimerEnd.

If you think this needs to be added as a functionality, please create an idea on the forum or up-vote if already created.

Hope this Helps!

Regards,

Ricardo

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Thank you @rimatos for your proposition.

Indeed OnTimerEnd is quite satisfactory for me. Is enough to add Timer button, set manually new "Refresh" instead of default counting time, and for OnTimerEnd set:

Refresh(sharepoint_list_name)

I have tested value time set for 500 and this solved the problem.

But finally your proposition directed me to set more automated and simple solution:
Just for drop down menu I have set action OnChange with the same "Refresh":

Refresh(sharepoint_list_name)

This refresh automatically and causing empty-filling HTML text filed for about 1 second after choosing drop down menu. For me this is satisfactory, hope for players of my app too.

Topic is solved for me, thank you!

Was this reply helpful? Yes No