how to get data in view form from SP list

(0) Share

Report

Posted on by tsunatsuna

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.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
tsunatsuna 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much!@v-monli-msft

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.

Was this reply helpful? Yes No
tsunatsuna 30 on at

Like (0)

Report
Copy link

Link copied!

@v-monli-msft
thank you

Why I need 3 screens is I just want to open attached file in online. But I think onselect action can use in editable form and action:editform(formname) or viewer form and action viewform(formname). that's why I need 3 screens.
If it can open attached file in online on view mode, that's fine.

Was this reply helpful? Yes No