how to copy a value from a field based on a condition

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a form in which users must select steps.
Each step will qualify the document file.

In the first step, the users input some information. I named it "fiche de faisabilité.

In the second step (fiche programme), i retrieve most of the information entered in the 1st step.

If i click on the button, it create a collection then i can select into the dropdown list named "sélectionner la fiche ..." the document i need. It fill the url fiche de faisabilité.

In the third step, I need to retrieve the previous url de faisabilité and I need to copy it to the corresponding column

But i don't knwo how to do that..this is the 1step of my formula.

If(dpd_etape.Selected.Value="Fiche programme";"https://afpa365.sharepoint.com/sites/Suividaffaires/_layouts/15/DocIDredir.aspx?ID="&LookUp('centre de documentation';Nom=dpd_recherche_etude.Selected.Nom).'Valeur d’ID de document')

I need to copy this information.

thanks for your reading and help

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
After a long good nignt, this morning i used this formula and it works

If( dpd_etape.Selected.Value = "Fiche programme"; "https://afpa365.sharepoint.com/sites/Suividaffaires/_layouts/15/DocIDredir.aspx?ID=" & LookUp( 'centre de documentation'; Nom = dpd_recherche_etude.Selected.Nom ).'Valeur d’ID de document'; dpd_etape.Selected.Value = "Proposition commerciale"; dpd_recherche_etude.Selected.'URL Fiche de faisabilité' )

But to you have a tip to make this url more readable ? It's ugly

Was this reply helpful? Yes No