Compare List and form title and filter

(0) Share

Report

Posted on by surya64

Hi All,

I have a question in powerApps Implementation. My requirements are:

1) Have two list in sharepoint (say List_1 and List_2 ) and each list have multiple records and I need to compare both the lists and filter the common records between them based on the unique title name.

2) after filtering, need to display common record from List_2 in readonly format next to the it's sibling record in List_1. and It has to update automatically in sharepoint List_1. (Basically the matched record form should contain both values from List_1 and List_2 in sharepoint List_1 when I open that record)

3) And for remaining uncommon items it has to display "not available" next to the each form in List_1

Thanks,

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (7)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

What is your question? We can help with specific questions, but we aren't going to just do your work for you.

Was this reply helpful? Yes No
surya64 12 on at

Like (0)

Report
Copy link

Link copied!

Sorry for late reply..
I have one form with set of fields. I need to compare title filed in a form with list of items from another gallery and if it matches, fetch the email value from gallery and add that column to the form.

Was this reply helpful? Yes No
surya64 12 on at

Like (0)

Report
Copy link

Link copied!

AddColumns(
[@List_1],
"Email",
LookUp(
'List 2',
Title in [@List_1].Title,
'Email'
)
)

This formula is working error free and works fine. But the column is not getting added to the "Add filed" section in order for me to drop on form.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

AddColumns does not directly impact the SharePoint List. It is adding a column to the in-memory representation of your list; not the list itself.

Was this reply helpful? Yes No
surya64 12 on at

Like (0)

Report
Copy link

Link copied!

So, Is there any solution to add that to the sharepoint form ?

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!
There is no OOB action in the SharePoint connector for "add a column to a SharePoint list" but there is a "Send HTTP Request to SharePoint".

If you follow the REST request pattern outlined here in the example for "how to create a custom field for a list" that is the process you would follow in the Send HTTP Request action. Sample request copied below for reference:

POST https://{site_url}/_api/web/lists(guid'{list_guid}')/Fields Authorization: "Bearer " + accessToken Accept: "application/json;odata=verbose" Content-Type: "application/json" Content-Length: {length of request body as integer} X-RequestDigest: "{form_digest_value}" { "__metadata": { "type": "SP.Field" }, "Title": "field title", "FieldTypeKind": FieldType value, "Required": "true/false", "EnforceUniqueValues": "true/false", "StaticName": "field name" }

Was this reply helpful? Yes No
surya64 12 on at

Like (0)

Report
Copy link

Link copied!

Do I need to send HTTP request to Sharepoint on button click?

Was this reply helpful? Yes No