Answered

Load item from SP List into Power Apps

(0) Share

Report

Posted on by Aaqib1

Hi,

I have created a Power App from scratch without embedding a form within it. I can successfully post all entries on the form to the SP List.

I want to now 'load a meeting' from the SP list into the actual Power App?

This is the Meeting Page, that I want populated based off the entries that are entered in the previous page

I have set up a Power Automate;

and subsequently on the Load Meeting button I have put in the following on the select button;

Set(varScheme Name_1,'PowerAppsbutton-3'.Run(varSchemeName).Text) but it doesn't seem to actually load that entry into the Scheme Name button.

Any ideas on how to overcome this?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@Aaqib1

In the Power App, you can use LookUp function to get desired item from your SharePoint list if you know SP List Item ID or any unique field value.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Syntax: LookUp( Table, Formula [, ReductionFormula ] )

Example: LookUp(<SharePointListName>,ID=<SPListItemID>)

You can use any specific field in the place of ID column if it is unique to identify the list item.

Give a try and post your response here.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Aaqib1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rsaikrishna

Thank you for the above.
I have updated the field as per the solution here;

LookUp('Meeting Form - AW', "Client Reference" = "AW123456", "Scheme Name")

This is my SP List where you can see the Scheme Name that I want to pull through into the field

Is it the formula that I have stipulated in the 'OnSelect' Action for the Scheme Name which is incorrect?