cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tsunatsuna Helper I
Helper I

how to get data in view form from SP list

please tell me;

How to get the data from SP list.

I want to make some screen regarding to new, edit and view. And if it make new file or title, it effect on view screen.

 

here are details;

I insert Forms, then choose data source:SP list, and i select Fields.

I added field, but it seems it can't have the data.

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: how to get data in view form from SP list

Hi @tsunatsuna ,

 

It seems that you are using the custom form created from SharePoint list. If so, may I know why you want to have 3 screens just for different display mode of Form control? Because by default, the custom form should have one form, and it will change its mode to View/Edit/New according to what user select on SharePoint list interface.

 

See more information about custom form here:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration

 

But if you insist to do so, you could follow below steps to achieve this:

1. Set below formula in the OnView property of SharePointIntegration control:

ViewForm(SharePointForm1);Navigate(showscreen,None)

2. Then set below formula in the Item property of FormViewer1:

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('YourListName'),SharePointIntegration.Selected)

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tsunatsuna Helper I
Helper I

Re: how to get data in view form from SP list

Thank you so much!@

 

I would like ask you two more things;

1.

I made a FormViewer, and I set action (sharepointintegration>advanced>action>ViewForm).

But error occur like this;

 the function expects an editable form as its input,

 the function has some invalid arguments.

 

2.

I set OnSelect action which Launch(ListBox1.Selected.AbsoluteUri & "?web=1"), meaning I can open attached file in online.

But I think it depends on whether Form and action. I made two form and two action.

sharepointintegration>advanced>action>ViewForm(Formname): not available Onselect(I can't click and can't open file)

sharepointintegration>advanced>action>EditForm(Formname): available Onselect(I can click and open file)

I want to use ViewForm and when I click attached file I can open the file online.

please tell me how to solve this.

tsunatsuna Helper I
Helper I

Re: how to get data in view form from SP list

@v-monli-msft 

 

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Users online (5,958)