Answered

Dropdowns not showing when trying to update form

(0) Share

Report

Posted on by PowerAppTom

Hi!

I have created a PowerApp form from a SharePoint list. the user clicks +New in SharePoint and the form comes up without problem. (they can add entries/use dropdowns).

Once saved, an email is sent to another user with the link to the form. When the second user clicks the link it opens the form, all the options drop-down options are gone and nothing is editable. (buttons still work). how can I fix this, please!

please see person 1 and person 2's view in the attachments.

(person two is unable to type anything in the box)

Thanks,

Tom

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerAppTom ,

I need to confirm some things from you:

1. What's the Items property of this dropdown? if it is populated from a list, does the second user has access permission to this list?

2. If a user open the form directly in the SP list to do some changes, does the dropdown work?

3. How do you get the form link in your email? Using Param function?

Please provide more information for helping us understand your question better.

Best regards,

Allen

Was this reply helpful? Yes No
PowerAppTom 50 on at

Like
a
(0)

Report
Copy link

Link copied!

1. The property of the column is a Choice (with one option), all users have access to the list.
2. once first created and saved, the form is no longer editable, even if opened directly in SharePoint by double-clicking the line item.
3. the link to the form is generated from a Flow, which uses the parameter to take them directly to the form associated with the entry in the list. 'Link to Item'
hope this helps.

Thanks,
Tom

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerAppTom ,

Seems the form is still in View mode even when user open it using email link.

So I would suggest you edit the DefaultMode property of your form to formula like below(replace to your own Param):

If(Not(IsBlank(Param("LinktoItem"))),FormMode.Edit,FormMode.View)

So that when user opens the form by email link, the Param will not be empty and the form will be in Edit View.

Best regards,

Allen

Was this reply helpful? Yes No
PowerAppTom 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I just tried this, unfortunately it didn't work.

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerAppTom ,

So I want to know how do you achieve "once first created and saved, the form is no longer editable"?

Maybe this issue is related to this setting method that even open through a URL link, the form still cannot changed into Edit mode.

To confirm my suppose, you can add a label outside the form(in the same screen of the form), and set its Text to:

Form1.DisplayMode

Then open this form by the email link, check if its value is "Edit".

Best regards,

Allen

Was this reply helpful? Yes No
Verified answer

PowerAppTom 50 on at

Like
a
(0)

Report
Copy link

Link copied!

For anyone who needs to refer to this;

The solution was changing the SharePointIntegration advanced properties.

I changed OnView from:
ViewForm(SharePointForm1)
to
EditForm(SharePointForm1)

Please see images

Was this reply helpful? Yes No