cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.
Highlighted
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.

Highlighted
Helper I
Helper I

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

@v-monli-msft 

 

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (10,582)