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