Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Merge two sharepoint list into csv file on powerapps using powerautomate

Like (1) ShareShare
ReportReport
Posted on 12 Sep 2024 10:00:50 by 6

I am creating a powerautomate flow on my powerapps to merged two sharepoint list in csv file using primary key of DRS_main which is seqNum and the foreign key of DRS_doctype which is seqNumRef and will send the output to email with csv file attached on my powerapps

I have two textboxes which are txtbox_filter_clientName and txtbox_filter_imexRefNum

and I have button with formula

Export_Tasks.Run( "startswith(clientName,'" & txtbox_filter_clientName.Text & "') or startswith(imexRefNum,'" & txtbox_filter_imexRefNum.Text & "')", User().Email );


Below are my sharepoint lists:

(1) DRS_main contains: seqNum (primaryKey), clientName, imexRefNum
(2) DRS_doctype contains: seqNumRef (foreignKey), address, gender

  • Suggested answer
    FLMike Profile Picture
    FLMike 27,286 on 12 Sep 2024 at 19:44:15
    Merge two sharepoint list into csv file on powerapps using powerautomate
    I answered this on your other thread
     
    Please dont post it in many places, we will see it where you put it, this just clogs up the community with a bunch of never responded, (from the creator)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading started
Loading complete